How do I convert a string field to a date so I can format it as a date?

Chris Dunlop

24 Mars 2021 16:39

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

• 

  Ash Petitjean

  22 December 2021 20:29

  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

Du måste logga in om du vill lämna en kommentar.