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

[grajmca_sgp123]

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 · Accepted solution]

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]

Thank you it is working as expected.