Using property expressions to convert a string to a date.

[Patrick_Haught2]

I have a file name being captured as part of a keyword    Example (X_XXX_XXXXX_07302020_XXX.TIF)

I'm using the arrayvalue function to grab the date segment of 07302020

I've tried the obvious format, cdate but I can't seem to turn 07302020 into 07/30/2020 so that it can then be saved to a date formatted keyword.

Thoughts?

Thanks.

[Larissa_Armand · Accepted solution]

If your dates will always be formatted as MMDDYYYY, this would work: 

Date(Right(%VpropInput;4);Left(%VpropInput;2);Right(Left(%VpropInput;4);2))

Regardless of the format, the Date() function should work better for you, CDate() would work if your date was already formatted as 07/30/2020 but as a string. Date() will take each value (year, month, day) and format that and treat it as a date data type.