How do I convert a string field to a date so I can format it as a date?
Hi. I'm creating a report that runs against a list of features. There is a string field that contains a date, in the format "12/31/2021 12:00:00 AM". I want to format it as "12/31/21". I tried the Text Format String option, but it doesn't work, I'm guessing because it's a string value, not a date. Do I need to convert it to a date? I couldn't find a function to do that. Any ideas, other than some complicated string parsing?
Thanks,
Chris
0
-
Hello Chris, use the format date activity and select L as the format.
https://docs.geocortex.com/workflow/latest/help/Default.htm#wf5/help/activities/format-date.htm
0
Please sign in to leave a comment.
Comments
1 comment