monthly schedule

[qv_testing]

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....

[#2]

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

[qv_testing]

Thanks for quick reply,

i want to calcuclate current date..

[#4]

Sorry but this also not help to understand.

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

[qv_testing]

i want to return between current date and end date

[#6]

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]

Hi

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

or

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

Hope it helps