Date format?

[Sean Roberts]

What is the appropriate format for date fields?

Tried many formats.
2016/12/31
2016-12-31
and full iso formatting.

[cid:image001.png@01D2AC92.8D093800]
[cid:image002.png@01D2AC92.8D093800]

--
Sean Roberts
Partner Engineering, EMEA
@seano