Set Analysis Later Than Date But Less Than Today

[Anonymous]

Hi

I am trying to create a set analysis which returns data which is after 01/04/16, but less than todays date.

I can get it to work for data after 01/04/16, but how do I include the Less than today.

Here is my current script :

=Count({<

state={'Recruited'},

[Booked start date]={'>=42461'}

>} Applicationid)

Any thoughts on how I can stop future dates pulling through?

Thanks

Phil

[Anonymous · Accepted solution]

Hi

check this

Assuming dates are in MM/DD/,YYYY format.

=Count({<state={'Recruited'},[Booked start date]={'>=01/04/16<=07/15/2016'}>} Applicationid)

OR

=Count({<state={'Recruited'},[Booked start date]={'>=01/04/16<=$(=Date(Today(),'MM/DD/YYYY'))'}>} Applicationid)

[Frank_Hartmann]

May be like this?

count({<state={'Recruited'},[Booked start date]= {"$(='>=' & 42461 & '<=' & Floor(Today())"}>} Applicationid)

[vikramv]

try like this with double quotes

=Count({<state={'Recruited'},[Booked start date]={">='01/04/16'<=$(=date(Today(),'DD/MM/YYYY'))"}>} Applicationid)

[Anonymous]

This worked with the following, slight adjustment.

Count({<state={'Recruited'},[Booked start date]={'>=01/04/16<=$(=Date(Today(),'DD/MM/YYYY'))'}>} Applicationid)

Thanks

Phil