Seperate number columns into date

2 posts / 0 new
Last post
Joined: 10/17/2019 - 11:21
Seperate number columns into date

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":
It provided the following date:

Brian Element's picture
Brian Element
Joined: 07/11/2012 - 19:57

Thanks for sharing.