topic Re: monthly schedule in QlikView

monthly schedule

Nagaraju_KCS — Wed, 04 Dec 2013 06:38:11 GMT

I have table in that start date and end date...

i want calculate current date

Start_date End_date

12/01/2011 01/01/2099

07/23/2011 08/08/2099

05/09/2013 12/31/2099

like this i want to calculate current date between 2 dates..

thanks in advance....

Wed, 04 Dec 2013 06:44:31 GMT

Plz explain calculate current date....??

Do you want to calculate

1.No of days from Start_date

2.and between current date and End_date

Nagaraju_KCS — Wed, 04 Dec 2013 06:47:36 GMT

Thanks for quick reply,

i want to calcuclate current date..

Wed, 04 Dec 2013 06:53:10 GMT

Sorry but this also not help to understand.

Please briefly explain what do you want to do or attach your app.

Nagaraju_KCS — Wed, 04 Dec 2013 07:05:41 GMT

i want to return between current date and end date

Wed, 04 Dec 2013 07:14:12 GMT

If i understand your query..

use Date(Now(),'DD-MM-YYYY')

it will return current date and you can calculate with it as you need.....

MayilVahanan — Wed, 04 Dec 2013 07:24:42 GMT

Do you need the records, which current date falls between start date and end date? If so, use interval match concept.

Where StartDate >= Date(Today()) and EndDate <= Date(Today())

Hope it helps