Solved: I need help with a Date formula (Past events or ev...

Marcegon · ‎12-05-2023

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 · ‎12-05-2023

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

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

BA_Pete · ‎12-05-2023

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

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

Marcegon · ‎12-06-2023

It worked! Thank you so much 🙂

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