topic Stuck - Can't form proper set expression for date range via input box in App Development

Stuck - Can't form proper set expression for date range via input box

mrbustin — Tue, 26 Dec 2017 23:20:19 GMT

I cannot figure out the proper syntax to get the proper set of records between a date range using two variables and input boxes.

I created vStartDate and vEndDate variables and capture them via two input boxes and then use date# to convert to dates but -cannot not get it to work... any helpwould be greatly appreciated. -Mark

count({$<ReceivedDate = {">= date#('$(vStartDate)','MM/DD/YYYY') <= date#('$(vEndtDate)','MM/DD/YYYY') "}>} TrackingNumber)

Re: Stuck - Can't form proper set expression for date range via input box

kenphamvn — Wed, 27 Dec 2017 01:50:38 GMT

Try this

count({$<ReceivedDate = {">=$(= date#($(vStartDate),'MM/DD/YYYY'))
<=$(=date#($(vEndtDate),'MM/DD/YYYY')) "}>} TrackingNumber)

Best regards,

An Pham

Re: Stuck - Can't form proper set expression for date range via input box

mrbustin — Wed, 27 Dec 2017 12:23:04 GMT

Thank you An!

I got it to work after making one tweak to your formula, I had to enclose the $expansion of each variable in single quotes:

count({$<FOIAType={'Request'},Status={'Closed'},DateReceived = {">=$(= date#('$(vStartDate)','MM/DD/YYYY'))<=$(=date#('$(vEndDate)','MM/DD/YYYY'))"}>} TrackingNum)

Thanks again An - I was banging my head against the wall

-Mark