Check if Date column contains dates that are within last month?

[SevsBo]

I'm struggling to determine if the Date column has dates within the last month. I have tried the following formulas, but they all omit the 31st of December 2024.

Option1:

IF(

    'Date'[CreatedDate] >= DATE(YEAR(TODAY()), MONTH(TODAY()) - 1, 1) &&

    'Date'[CreatedDate] <= EOMONTH(TODAY(), -1),

    TRUE,

    FALSE

)

Option2:

IF(

    'Date'[CreatedDate] >= DATE(YEAR(TODAY()), MONTH(TODAY()) - 1, 1) &&

    'Date'[CreatedDate] <= EOMONTH(DATE(YEAR(TODAY()), MONTH(TODAY()) - 1, 1), 0),

    TRUE,

    FALSE

)

Option 3:

IF(

    'Date'[CreatedDate] >= EOMONTH(TODAY(), -2) + 1 &&

    'Date'[CreatedDate] <= EOMONTH(TODAY(), -1),

    TRUE(), FALSE()

)

[SevsBo · Accepted solution]

Found the solution, posting here in case anyone has the same issue:

My CreatedDate column was formatted as DATETIME, so I first had to convert it to DATE:

CreatedDateV2 =

DATE(

    YEAR(' Date'[CreatedDate]),

    MONTH('Date'[CreatedDate]),

    DAY('Date'[CreatedDate])

)

Then I used this V2 version with the following formula:

IF(

    'Date'[CreatedDateV2] >= EOMONTH(TODAY(), -2) + 1 &&

    'Date'[CreatedDateV2] <= EOMONTH(TODAY(), -1),

    TRUE(), FALSE()

)

Works perfectly!

[Anonymous]

Hi @SevsBo 

Glad to hear you solved the problem yourself! Thank you for sharing!

Best Regards,
Yulia Xu