Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Julians Date

Hello, How can i convert this Date to normal Date.   Thx in advance for your help
Need Help
slorin's avatar
slorin
Super User
3 years ago

I need more information

What is the formula?
What is the error message?

 

Stéphane

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Here ist how GJ is appearing, when i try to insert the code you gave me it shows no error as shown below:

When i click on "OK" the result appears like this:

 

  • slorin's avatar
    slorin
    Super User
    3 years ago

     #date(2023,1,Number.From([GJ])

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      In "GJ" i have the year 21, 22 and 23. THe formular you gave me will be like this;

       

      • slorin's avatar
        slorin
        Super User
        3 years ago

        I don't understand what do you want : 01/01/2021, 01/01/2022 and 01/01/2023 ?

        #date(Number.From("20"&[GJ],1,1)