Converting numbers to date

[Anonymous]

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

[rwunderlich]

The expression will be false if there is more than one date.

-Rob

[Anonymous]

yes, that's why i am asking what should i do to make it right if there is more than one date selected

[arvind_patil]

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

[passionate]

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

[balar025]

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

[tresesco]

May be this?

=Max(if(Date(mydate,'MMM-YY') = 'Jun-2017',1, 0))

[rwunderlich]

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