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

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!