Unable to filter the date dimension based on from and to dates

[kiranb13]

Hi Team,

I want to filter date dimension (derived dimension)  from vFromDate and vToDate.

=if([Onboarding Date_F]>='$(=vFrom)', if( [Onboarding Date_F]<='$(=vTo)'),([Onboarding Date_F]),'FE').

Here the problem is it is working for From Date. It's not working for ToDate. I have cross checked variable.

I am getting proper variable values. Can someone suggest how to proceed or suggest alternate solution?

Regards,

Kiran

[kiranb13 · Accepted solution]

Hi Team,

Below one worked.

if(Date#([Onboarding Date_F],'DD/MM/YYYY')>=date#('$(=vFrom)','DD/MM/YYYY') and
Date#([Onboarding Date_F],'DD/MM/YYYY')<=date#('$(=vTo)','DD/MM/YYYY')
,Date([Onboarding Date_F],'DD/MM/YYYY'))