Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Custom Column with TODAY'S DAY function

Hi All,

I'd like to know how could I calculate the today`s date into a column + 1 for each row so, each row will be today`s day + 1?

In this cenario as shown below, I got the sequency numbers already but I cant do the funcion and say something like 
= DateTime.LocalNow + [Custom]
but seems like I`m not able to do it, sorry I`m learning M languge yet.


Thanks a lot!

Need Help
  • jeroendekk's avatar
    jeroendekk
    4 years ago

    Dear Anonymous 
    You could add a custom column with the following formula

    Date.From(Date.AddDays(DateTime.LocalNow(),1))

     

    Best regards,
    Jeroen Dekker

    If this post     helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!

2 Replies

  • jeroendekk's avatar
    jeroendekk
    Responsive Resident
    4 years ago

    Dear Anonymous 
    You could add a custom column with the following formula

    Date.From(Date.AddDays(DateTime.LocalNow(),1))

     

    Best regards,
    Jeroen Dekker

    If this post     helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!