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
az38 This formula works, but, with the one your provided. For the date range of (192020) I'm getting December 30th of 2019. Can you help me restructure the formula for that date range to bring back 5/3/2020?
Hi Anonymous
for me it works
what kind of Date lead you to mistake?
