Date as column type converts the date into US format but not accurately and hence makes the data ina

Preetha Luther

Column 60 is the accurate information Creation date has had the type specified as Date, it did not work with the dates in march until the 11th of March and likewise for the 1st of april. I am unable to understand the pattern either, can the Date format be used in dd//mm//yy format please

 

Kennedy Stomps

Hi Preetha-- The date format you see you in Smartsheet is based on the location indicated for your account. You can click Account (upper left corner) > Personal Settings, change the "Language (Country)" to your location, then click the blue "Save" button. Smartsheet will refresh to display the dates in the format appropriate for your location. Hope this helps!

Andrew Lugton

Hi Kennedy - take a look at my comment on this subject: https://community.smartsheet.com/discussion/date-format-inconsistencies-usuk

 

 

 

J. Craig Williams

When in doubt whether Smartsheet is confused by the date format (and it can be) use the MONTH() function to be sure if 11/03/16 is March 11th or November 3rd.

 

Another reason we will never have world peace. Everyone is going to show up, but the other side won't be there because they misunderstood the date.

 

ISO-8601 or bust!

 

Craig