Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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(...
Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

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's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you for your reply.

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

       

      Regards

      Sam