Custom column to return "Expired" value if date within a different column is older than six months

[HarperCash]

I'm trying to create a custom column that will check the date qwithin an existing column named Last Updated and determine if the date is six months older than the current date. If it is I want to return a value of Expired, if not thana value of Compliant.

I have tried the below:

if [#"Last Updated:"] = 6 < DateTimeZone.LocalNow then "Expired" else "Compliant")

[DOLEARY85]

HI,

You could try this:

= if [Last Updated] < DATEADD(DateTimeZone.LocalNow(), -6, MONTH) then "Expired" else "Compliant"

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[HarperCash]

Thanks so much!

Getting errors saying it doesn't recognise DATEADD and MONTH

[DOLEARY85 · Accepted solution]

Apologies, I wasn't looking at the power query side of things

try this:

if [Last Updated] < Date.From(Date.AddMonths(DateTime.LocalNow(), -6)) then "Expired" else "Compliant"

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍