Today between two dates !!

[Anonymous]

I have this kpi, how to compare today date between start date and end date ???

[tamilarasu]

Hi Bayan,

You can use above SQL query directly in Qlikview. Are you getting any error?

[eduardo_dimperio]

Maybe This

SYSDATE() between TO_DATE([start_date]) and TO_DATE([end_date])

[Anonymous]

I am using Qliksense not Qlikview

[Anonymous]

I will try it .

thanks.

[eduardo_dimperio]

Me too

[tamilarasu]

Is this not working in QlikSense? Did you get any error?

[fabdulazeez]

count({<effectivestartdate= {"<=$(=Today())"},effectiveenddate= {">$(=Today())"}>} distinct person_key)

[eduardo_dimperio]

No, what error did you receive?