How to Filter records within 3 days from today date in an encodedquery?

[Sucharitha2]

Filter records within 3 days from today date in an encodedquery?

I have field called vendor ship date on the form. If vendor ship date falls within 3 days from current date then include this in encoded query.

Example: As today is 18th, I want the vendor ship date field records as 19th, 20th and 21st -> which are 3 days.

I tried using relative after but no luck

[Basheer]

Hi @Sucharitha2 

Let us consider delivery is your field

addEncodedQuery("u_delivery_dateRELATIVEGT@dayofweek@ahead@3);

[Basheer]

Try this, it worked for me, just replace u_delivery_date to your column name

u_delivery_dateRELATIVEGT@minute@ahead@0^u_delivery_dateRELATIVELT@dayofweek@ahead@3

[Sucharitha2]

Hi Basheer,

Thanks for the help. I tried this query "vendor_ship_dateRELATIVEGT@minute@ahead@0^vendor_ship_dateRELATIVELT@dayofweek@ahead@3" which was given by you but it did fetch records of 19th and 20th but not 21st. I want records of 21st as well.

I didn't really understand the query given by you because I see relative before which gives previous ones. Could you please explain me the query given by you?

[Basheer]

Hi @Sucharitha2 

See the below screenshot and just change delivery date to your column name.

Let me know if you need more help.