I have a script to pull specific data from a db and I need to pull an additional DATE data field called 'createdate' showed in the second line below. Using the STRING data type did not give me the correct date value. What is the right syntax for the result to display DATE value correctly?
PUT UNFORMATTED string(invcost.cost) + ";".
PUT UNFORMATTED (invcost.createdate)
Appreciate any helps.
IF you're doing both of these fields then use export instead of put
export delimiter ";" invcost.cost invcost.createdate format "99/99/9999"
You don't say what was incorrect, but note that string() can take a second argument to specify a non-default format.