ISO dates

[apparelbusiness.com]

Good morning, I was following one of the diaries Old school dates, and thought I had done it correctly but the date on the form is not displaying the date picker. I have attached the different screens showing how I set it up. Is there something else must be set ?

datepicker.docx

[robert.swanson]

Whoops -- you found a typo in the SQL statement in that blog post! You just need to wrap your TIMESTAMP_FORMAT in DATE(), so it should look like this:

date(timestamp_format(char(cpshpd), 'YYYYMMDD')) as shipdt_iso

Without the DATE() part it comes through as a timestamp.

I just corrected the blog post, thanks for the heads-up!

[apparelbusiness.com]

Thank you that did the trick.