expression: using a time span

[Anonymous]

=Count(date_scheduled_fixed>vToday and date_scheduled_fixed<DayStart(Today()+7))

dont look at that as actual qlik code, but what would be the correct syntax for something like this.

I just want to show the number of dates between today and 7 days from now.

[vishsaggi · Accepted solution]

May be this?

=Count(IF(date_scheduled_fixed>vToday and date_scheduled_fixed<DayStart(Today()+7, date_scheduled_fixed))

missed a parenthesis

=Count(IF(date_scheduled_fixed>vToday and date_scheduled_fixed<DayStart(Today()+7), date_scheduled_fixed))

[Anil_Babu_Samineni]

May be you missed parenthesis

=Count(IF(date_scheduled_fixed>vToday and date_scheduled_fixed<DayStart(Today()+7), date_scheduled_fixed))

[vishsaggi]

Yes. I missed for DayStart(). Thank you.

[Anonymous]

Thank's alot, the solution Vishwarath gave worked.