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/2020) as the sunday is the first day of the calander year. 

 

Any help with this would be great, thank you!

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

9 Replies

  • 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

    Hello everyone,

     

    I am working on a CurryShots file and I want my Date to be displayed as DD/MM/YYYY. I tried changing the the data type using locale to English (uk) and English (Au) but it stills shows as this error;

     

    "We couldn't parse the input provided as Date value.

    Details:

         10/28/09"

     

    Can anyone please help me solve this issue 🙂

    Thankyou!