First time here? Check out the FAQ!
0

Download time limit no effective

Hello,

We want download data and setup time schedule as ( L_StatusDate ) "$Date='2017-05-01T06:00:00-2017-06-01T05:59:59';"

query as : $get_url = 'http://rebrae.retsiq.com/contact/rets/Search?SearchType=Property&Class='.$key.'&QueryType=DMQL2&Format=COMPACT-DECODED&StandardNames=0&Query=(L_Status=2_0),(L_StatusDate='.$Date.')&Select=L_StatusDate,.............. ';

when we get data, some date is in 2017-06-01, but it seems after 6 am. like E4044434,E4044660,E4046135,E4054238 E4059844,E4059933 .....

It seems time limit is not useful for L_StatusDate. Please let me know. Thanks,

Charles

charles@ereb.com's avatar
charles@ereb.com
asked 2017-06-05 13:41:09 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

2 Answers

0

If you are just looking to download data for the month of May for example. Since it is a Date field, this date range should work: 2017-05-01-2017-05-31.

bwolven's avatar
bwolven
answered 2017-06-05 14:14:35 -0500
edit flag offensive 0 remove flag delete link

Comments

How about time, since you are UT time. So we need '2017-05-01T06:00:00-2017-06-01T05:59:59'. Can we ?

charles@ereb.com's avatar charles@ereb.com (2017-06-05 14:31:03 -0500) edit
add a comment see more comments
0

Do u mean there is no time limit on L_StatusDate? We want to take data before June 1,2017 6:00 am on L_StatusDate.

When we get data L_StatusDate, it only has date no time. So we check paragon system some data out of time range. They are after 6 am. Please let us know. Thanks, Charles

charles@ereb.com's avatar
charles@ereb.com
answered 2017-06-05 14:23:18 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

Your Answer

Login/Signup to Answer