Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
May be like this?
count({<state={'Recruited'},[Booked start date]= {"$(='>=' & 42461 & '<=' & Floor(Today())"}>} Applicationid)
try like this with double quotes
=Count({<state={'Recruited'},[Booked start date]={">='01/04/16'<=$(=date(Today(),'DD/MM/YYYY'))"}>} Applicationid)
This worked with the following, slight adjustment.
Count({<state={'Recruited'},[Booked start date]={'>=01/04/16<=$(=Date(Today(),'DD/MM/YYYY'))'}>} Applicationid)
Thanks
Phil