Long date to Short

[Kevin]

simplest way to convert timeformat string   back to Date format  in this case is remove the day and first comma and then can be converted back to Date

Code:

Copy      Help

str s.timeformat("{DD}")
out s
// remove day and comma from string
int i = find(s "day," 0 1)
s.remove(0 i+4)
s.trim
out s
//convert to Date
DATE d1(s)
out d1
//convert to DateTime if needed
DateTime d.FromStr(s) ;;;directly from string
out d.ToStr(1)
DateTime d2.FromDATE(d1);;from Date
out d2.ToStr(1)