Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have date field called "Start Date" and it is in a format "10/31/2015 12:01:00 AM".
I want to get count(Start Date) for recent two dates.
If today is 2015/11/02 then i have to display 2015/11/02 and 2015/11/01.
I used =count({$<Start Date={"=Start Date>=Now(1)-2"}>}Country) as one expression and
=count({$<Start Date={"=Start Date>=Now(1)-1"}>}Country)
please check my attache excel sheet.
I have used your expression, but when i take Date(now()-2) and Date(now()-1)
It gives same vales