Results 1 to 4 of 4

Thread: Custom Column with yesterday's date

  1. #1

    Custom Column with yesterday's date



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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()

  2. #2
    Try:

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

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

  4. #4
    Thank you Brian, that worked perfectly.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •