Are tokens tied to a date field kept as dates or converted to strings

684
1
04-12-2017 09:30 AM
deleted-user-7uOyUeQXbkI0
New Contributor III

We have an extended property that stores a date in a date field type.  In a subsequent step we use a token to pass along that date as an argument to run another tool, but we are getting errors saying input is not in the proper format.  Is this because the token passes it along as a string and not as a date?

0 Kudos
1 Reply
deleted-user-59NIbCq7H8Ve
New Contributor II

Hi Ryan, 

My experience with passing extended property tokens of data type is similar to yours.

By intercepting the token value, I found out that the date value is formatted as a string using the locale settings of the client. E.g.: if you run the step from WFM on Windows, the resulting string will be based on the OS settings for the current user.

Best Regards,

Laurens

0 Kudos