I need help with a Date formula (Past events or events taking place within (2) weeks from today.

[Marcegon]

Hi, I have the formula below in Alteryx and I need to translate into Power query.  Any help would be greatly appreciated.

Past events and events taking place within (2) weeks from today:

DATETIMEPARSE([Start Date], "%Y-%m-%d") <= DATETIMEADD(DATETIMENOW(), +14, "days")

Thank you.  

[BA_Pete · Accepted solution]

Hi @Marcegon ,

I'm not 100% on what the Alteryx DATETIMEPARSE function is doing, but I'm thinking something like this in Power Query will do what you're after:

DateTime.From([Start Date]) <= Date.AddDays(DateTime.LocalNow(), 14)

Pete

[Marcegon]

It worked!  Thank you so much 🙂