4 Replies Latest reply: Jul 15, 2016 4:21 AM by Phil Speight

Set Analysis Later Than Date But Less Than Today

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

• Re: Set Analysis Later Than Date But Less Than Today

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)

• Re: Set Analysis Later Than Date But Less Than Today

This worked with the following, slight adjustment.

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

Thanks

Phil

• Re: Set Analysis Later Than Date But Less Than Today

May be like this?

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

• Re: Set Analysis Later Than Date But Less Than Today

try like this with double quotes

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