Hi I have date which is in text format, sample date is "2013-04-02 00:00:00

Sumeet Khare over 11 years ago

Hi I have date which is in text format, sample date is "2013-04-02 00:00:00.000". let me know how to convert it into date as todate & todateTime are not working on this format....

Discussion posts and replies are publicly visible

Parents

0 Mike Schmitt
Certified Lead Developer
over 11 years ago

For whatever reason, the ISO 8601 date format (YYYY-MM-DD) is not supported by the todate() function (or by the date picker); in your case you can try splitting the date and time apart using the split() function or similar, then following the previous commentor's suggestion, call the date() function after splitting the date portion on the dash ("-") character.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Mike Schmitt
Certified Lead Developer
over 11 years ago

For whatever reason, the ISO 8601 date format (YYYY-MM-DD) is not supported by the todate() function (or by the date picker); in your case you can try splitting the date and time apart using the split() function or similar, then following the previous commentor's suggestion, call the date() function after splitting the date portion on the dash ("-") character.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data