Forum Discussion
Column to Identify Less than or equal to Today + 1 month
I want to add column to a table to Identify all rows that are <= Today() + 1 month.
I tried using
DATEDIFF(Table[date], DATEAADD(TODAY(), 1 MONTH)
But I got error since DATEADD takes a series not a singe value.
how can I resolve this?
You can get the date for today + 1 month with
Today + 1 month = DATE( YEAR(TODAY()), MONTH(TODAY()) + 1, DAY(TODAY()))
1 Reply
johnt75Super User
You can get the date for today + 1 month with
Today + 1 month = DATE( YEAR(TODAY()), MONTH(TODAY()) + 1, DAY(TODAY()))