Date column formula

[Anonymous]

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(Date.From(DateTime.LocalNow()))}

i was doing this report by taking help from youtube videos.

Sam

[Nathaniel_C]

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

[Nathaniel_C]

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

[Anonymous]

Thank you for your reply.

could you please tell me why i am not getting those numbers..

Regards

Sam