Custom Column with yesterday's date

KCantor

New member

Joined

Apr 4, 2016

Messages

15

Reaction score

0

Points

0

• Apr 26, 2016

• #1

I need to add a custom column to a table with yesterday's date and then convert it to a month. I know this sounds odd but the calculations are for a monthly report. If I were using DAX I would use something along the lines of TODAY()

 

B

Brian Smith

New member

Joined

Apr 1, 2016

Messages

57

Reaction score

0

Points

0

• Apr 26, 2016

• #2

Try:

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

 

B

Brian Smith

New member

Joined

Apr 1, 2016

Messages

57

Reaction score

0

Points

0

• Apr 26, 2016

• #3

Sorry - wrap Date.Month around that to get month of yesterday's date.

 

KCantor

New member

Joined

Apr 4, 2016

Messages

15

Reaction score

0

Points

0

• Apr 26, 2016

• #4

Thank you Brian, that worked perfectly.