Forum Discussion
Date conversion
Hello, I'm looking to get a conversion of a whole number date I have to an actual date. Current format is in week year ex. (192020) I would like this to read as May 4th 2020 or (4/4/202...
Hi Anonymous
create a calculated column
Column = VAR _week = LEFT([Date],2) VAR _year = RIGHT([Date],4) RETURN DATE(_year, 1, -2) - WEEKDAY(DATE(_year, 1, 3)) + _week*7
