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 

for me it works

 

what kind of Date lead you to mistake?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

az38  I figured it out. My original number was still sitting in text format. Needed to be changed over to whole number. Thank you very much for your help!

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Anonymous 

    it should work with text data type as well

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    5 years ago

    @kfitz20

    it must work with the text data type as well