Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey, I cant get the right value using this expression
=if(Date(mydate,'MMM-YY') = 'Jun-2017',1, 0)
if I select 1 date it will give me the right one, but if select more than 1 it give me zero
The field 'mydate' is in numbers format
The expression will be false if there is more than one date.
-Rob
yes, that's why i am asking what should i do to make it right if there is more than one date selected
Hi Mike,
I think you need to create master calendar and calculate monthyear field then it works if you selected month year then it shows all respective date.
Thanks,
Arvind Patil
Hi,
Do you want this in script :
PFA, Solution in Script.
Create a numeric value for date and use this Numeric value in expression.
Regards,
Pankaj
Hi,
You can use below function
if(Num(mydate)>=Num(MakeDate(2017,06,01)) and Num(mydate)<=Num(MakeDate(2017,06,30)),1,0)
Regards,
Ravi balar
May be this?
=Max(if(Date(mydate,'MMM-YY') = 'Jun-2017',1, 0))
What context do you want to make this test in? You want it to be true if the date "Jun-2017" exists in the selection? Or you only want to aggregate rows where that is true? Is this an expression in a chart or some other expression?
-Rob