Forum Discussion
Date column formula
I was trying to get date of joining in the formulated way to prepare the attrition report but i was getting error while customize the column with below formula. = { #"Date of Joining" ..Number.From(...
Hi Anonymous ,
What are you trying to do? Are you trying to get the immediate time in a calculated column? Then NOW() should be sufficient. Please give us more information.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Hi Anonymous ,
Or if you are working in Power Query the formula Table.AddColumn(#"Changed Type1", "Custom", each Number.From(Date.From(DateTime.LocalNow()))) that you posted does work. I then get a number back.
See picture. Perhaps you are putting the code somewhere other than Power Query?
Give us more details...
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel