Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Yesterday date

So I am trying to generate a calendar from yesterdar so I tried #date(Date.Year(DateTime.LocalNow()), (Date.Month(DateTime.LocalNow())), [dias]) where dias is a column where I am getting from the day...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous - Try:

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

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

 Hi, 

Greg_Deckler your solution works for a similar question I had, however can you please let me know how to remove the time that is returned next to the date? What I see when i use 

 

is 23/12/2021 13:30:17

I would like to remove the hour/minutes/seconds please.

 

Many thanks

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    Anonymous Just format it as only a date and note a date/time.