Query on or after 16th of every month

4 replies
1560 views
Translate All

Hi Team,

We have a recurring campaign that runs once in a month and needs to check if a customer has an entry on or after 16th of previous month. can someone help on how to query the same, thanks in advance.

Thanks,

Shine v.v

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

Shubham_Goyal__Accepted solution

Level 6

Hi @shinev_ ,

Instead of going with Js calculation try this simple function in your query activity and see if this helps:

ToDateTime('"' + toString(Year(MonthsAgo(1))) + '-' + toString(Month(MonthsAgo(1))) + '-16T00:00:00.000Z')

Here you use the ToDateTime function which calculates the date from the input string and in the input string you can calculate the Year of last month and the month of last month and hard code rest like 16 in your case.

See if this gives you desired results.

Br,

Shubham

~Thanks - Shubham Goyal (Enterprise Architect)