Forum Discussion
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 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 - Try:
Date.AddDays(DateTime.LocalNow(),-1)
4 Replies
Anonymous
DateTime.LocalNow() - #duration(1,0,0,0)if you prefer a form of subtraction.
Anonymous - Try:
Date.AddDays(DateTime.LocalNow(),-1)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
Anonymous Just format it as only a date and note a date/time.
