Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am using below formula to showcase numbers that are closed on this month:
CommonDateNum={">=$(=Num(MonthStart(Max(CommonDateNum)))<=$(=Max(CommonDateNum))"
But I can see that there are still some tickets that are not coming after applying this condition,i thought that "=" is not working in the below condition,so I added -1 in the expression to consider all values.
CommonDateNum={">=$(=Num(MonthStart(Max(CommonDateNum))-1))<=$(=Max(CommonDateNum)-1)"
Please let me know if this condition is fine or do I need to change something....
Thanks in advance.
Hi,
What is your CommonDateNum Format??
Make modification as per CommonDateNum Format.
Use Date() to format your date in set analysis
max(CommonDateNum) -----> returns date in numeric format.
For debugging your script test output of your expression in text object
create 2 text object 1 with expression
=Num(MonthStart(Max(CommonDateNum))-1)
2nd with
=Max(CommonDateNum)-1
Both output format match with you CommonDateNum format.
Regards,
Prashant
Yes, i tried this flag but when I am selecting "1",it is selecting "MAY 2017".
Yes,my date field has both date and timestamp in it.,
then try as below
FABS(inmonthtodate(Timestamp#(<Datefield>,'DD/MM/YYYY H:mm:ss'),today()-1,0)) as MTDFLAG
Replace with your datefield format 'DD/MM/YYYY H:mm:ss'