I had three number columns that I needed to concatenate as a date field. Here is what I figured out:
Appended a column, virtual date, and the following formula which concatenates and turns the number fields (@str) into a character field THEN "Character to Date":
@Ctod((@Str(MO,2,0)+@STR(DY,2,0)+@Str(YR,4,0)),"MMDDYYYY")
It provided the following date:
"mm/dd/yyyy
RTAIDEA
Offline
Last seen: 3 years 11 months ago
Joined: 10/17/2019 - 11:21
Thanks for sharing.