Using the Weekday function in a query

Forum|Forum|1 year ago
July 31, 2024
2 replies
924 views

Hi,

I want to send a delivery to passenger who are scheduled to flight in a certain date range.
This delivery is only relevant to flights departing on Mondays within the given date range.
How do I use the "taken into account if" in the query for the DPT (departure date) parameter?

Thanks,
Marie

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by vt0509

Hi @mariba ,
Use it like this:
Change eventDate with your custom date.

DavidKangni

Community Advisor

Hi @mariba

I tried WeekDay(@lastModified)=0 in take into account if but It's not working as expected.

I will suggest you to enrich the daya with this WeekDay(@lastModified) and then use a split to exclude when the returned value is different from 0 (0=Monday -- 6=Sunday)

Thanks,

David

David Kangni

V

vt0509

Level 3

Hi @mariba ,

Its working for me. Use function WeekDay(@Date) equal to 0, alongwith the date range you want to select.