Support Article

String to Date conversion not working as expected



User have a requirement to format the date to YYYY-MM-DD.

When user is using the @String.todate() function to convert string to date they are getting default value for a date type property.

For example, the value of the date type property should be like 2016-01-01 but its appearing as 19700101.

Error Messages

Not Applicable

Steps to Reproduce

1.Convert a date to yyyy-MM-dd format using formatDateTime() function.
2.Convert the output string to date using @String.toDate() function.

Root Cause

Not Applicable


Here’s the explanation for the reported behavior:

It is not possible to store the time in different formats.

Note that Date objects have no format.

To get a formatted string with "-", One has to convert to String.

Published February 26, 2017 - Updated March 13, 2017

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.