Forum Discussion
Julians Date
Hello,
How can i convert this Date to normal Date.
Thx in advance for your help
16 Replies
Hi
= Table.TransformColumns(Prev_Step,{{"GJ", each Date.FromText(_, [Culture = "de-DE"]), type date}})Stéphane
Add column
Date.FromText([GJ], [Culture = "de-DE"])
Stéphane
Hello Gaucho.
I think what you are asking is to display date in format of dd:mm:yyyy
You can change that here
Hi Idkpowerbi
No it is not what i am trying to do. In My screenshort you can see that there is always "1900". That is already problem i want to solve.I cannot understand your logic in getting from what you show to what you want
Please show
- Your original data
- If your data is confidential, then make up some data that demonstrates the problem
- Best to post this as text or an Excel table which can be copy/pasted.
- A screenshot of your desired results from that data
- Your current code
- To obtain this:
- Select "Advanced Editor"
- Copy the contents of the window that opens
- Open the Code Sample window here `</>`
- Paste the code into the Window
- To obtain this:
- A statement of your logic in going from your original data to your desired results
As an aside, you are not showing any Julian dates (or dates from a Julian Date Calendar) in the data you have shown us so far, so I especially don't understand the significance of your question title.
- Your original data
