On or before a certain 'Date' using Javascript.

[bhaskarc1289447]

Hi All,

I have a requirement where I have to get select data from a range of date.

I am currently Using @partyDate >=  parsed_Date in querydef where condition.

But the data being returned is incorrect.

is the syntax correct. How do I pass 'on or after' parsed_Date in querydef where condition in javascript.

Please help.

[David_Loyd]

ACC has its own data format. Check out this link to format the date correctly. 

https://experienceleague.adobe.com/developer/campaign-api/api/f-formatDate.html

[Jyoti_Yadav · Accepted solution]

Hi @bhaskarc1289447 ,

Convert both dates to same format and then compare.

You can do something like:

const myDate = formatDate(result.@mailDate, "%4Y/%2M/%2D %02H:%02N:%02S")

Thanks,

Jyoti