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

kiranb13 — Fri, 07 Oct 2022 12:27:11 GMT

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

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

kiranb13 — Fri, 07 Oct 2022 13:15:26 GMT

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'))

topic Re: Unable to filter the date dimension based on from and to dates in App Development

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

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