Solved Conversion Text to Date

[bfb1892]

Hey guys,

Problem: Convert a text data item to a date that starts with "0". The "0" disappear everytime I convert a text data item that starts with "0" to a date data item.

Example:

text data item: 01/12/2017
date data item: 1/12/2017

Does anyone have a solution for that?

Thanks much.

 

[amanbareilly]

Use the function "ToDate()" like I have in the attachment. I put date like 01/12/2017 in text data item and got output like 01-12-2017. The slash was changed with the hyphen if that is not an issue but the 0 was still there.

 

[tgundhus]

Format is controlled by the resources' regional settings.

 

[Tolani]

As aman has suggested, use the ToDate () instead of explicit casting your values by saving into a date data item. I hope this helps.