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)
Try some thing like
count({$<Start Date={"=Start Date>=Date(Now(1)-2)"}>}Country)
Hi AnuRadha,
Check the below one,
Count({$<Start Date={">=$(=Date(Now(1)-2,'DD/MM/YYYY hh:mm:ss tt'))"}>}Country)
First make sure format of both the dates is same.
You can take two variables like:
VStartDate=date(FieldName,'DD/MMM/YYYY')
VTodayDate=Date(Now(), 'DD/MMM/YYYY')
then your expression like:
=count({<StartDate={'>=$(=VStartDate)<=$(=VTodayDate)'}>} Country)
Hope This will Help!!!
Any of those solutions doesn't work.
Hi,
Try like this
=count({$<[Start Date]={">=$(=Date(Today()-1))<=$(=Today()) "}>}Country)
Note: Date format Start Date and Today should be in the same format.
Hope this helps you.
Regards,
Jagan.
Share the sample data..
Hi Please use below excel, here mydate shows the date field i have
hi,
=count({<[MY Date]={">=$(=Date(now()-2) ,'MM/DD/YYYY hh:mm:ss tt')"}>}Country)
Working for Date level, check once
Hi,
try this..
=Count({<[MY Date]={">=$(=Timestamp(Max(Floor([MY Date])-1)))"}>}Country)