Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • az38's avatar
    az38
    6 years ago

    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's avatar
az38
Community Champion
6 years ago

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
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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?

    • az38's avatar
      az38
      Community Champion
      6 years ago

      Hi Anonymous 

      for me it works

       

      what kind of Date lead you to mistake?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago