Yesterday date

[Anonymous]

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 but I need to state the month and year based on yesterdar rather than today since on th 1st of every month I need to display the information of the 30th/ 31st of the last month. "DateTime.Localnow()  -1 " doent work

[Anonymous]

 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]

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

[CNENFRNL]

@Anonymous 

DateTime.LocalNow() - #duration(1,0,0,0)

if you prefer a form of subtraction.

[Greg_Deckler · Accepted solution]

@Anonymous - Try:

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