topic Load the values where present date is between DATEFROM and DATETO fields in App Development

Load the values where present date is between DATEFROM and DATETO fields

grajmca_sgp123 — Fri, 15 Nov 2024 21:01:59 GMT

Hi Community,

I tried looking for this but could not find a solution

I have a requirement to load the values where present date is between DATEFROM and DATETO fields.

Could you please help me out , What script do I use and how do I do it. I tried using the Today() with interval match function but did not work

Below is the sample data.

Input Data:

Expected output:

Thanks

Rajesh G

LRuCelver — Tue, 12 Mar 2024 15:38:35 GMT

This should be a simple where statement. Depending on whether your DATEFROM and DATETO fields are formatted as dates or integers try one of the two:

Dates:

Where DATEFROM <= Today() and DATETO >= Today()

Integers:

Where Date#(DATEFROM, 'YYYYMMDD') <= Today() and Date#(DATETO , 'YYYYMMDD') >= Today()

grajmca_sgp123 — Tue, 12 Mar 2024 16:28:52 GMT

Thank you it is working as expected.