Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

On or before a certain 'Date' using Javascript.

Avatar

Level 3

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.

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

0 Replies

Avatar

Correct answer by
Community Advisor

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