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
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!

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

@kfitz20

it must work with the text data type as well