Formatting DT object to string in Logic

[rlao]

Hello,

What is the easiest way to have a logic program format a DT object into a particular string format to be written out to a string field? FORMATVAL is for expressions and I can't find an equivalent function in the help. Worst case is I can extract the individual time, day, month, year fields as integers and convert to string but there's got to be an easier way right?

[AdamWoodlandToo · Accepted solution]

You can use EXTRACT_DT_YEAR, EXTRACT_DT_MONTH, etc and then CONCAT then back together in the order you want (with some DINT_TO_STRING thrown in)