Forum Discussion
Julians Date
Hello, How can i convert this Date to normal Date. Thx in advance for your help
I need more information
What is the formula?
What is the error message?
Stéphane
The syntax is showing no error but when i click on Okay, it shows me "ERROR"
I can't help you without your formula, a screenshot, your previous step, the error message...
I took de Data with "GJ" in JDE but i couldn't convert it to date, that is why i was trying to get a solution how to manage it .
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:
#date(2023,1,Number.From([GJ])
In "GJ" i have the year 21, 22 and 23. THe formular you gave me will be like this;