How do I calculate what next week's date will be? 2

[rleiman]

Hi Everyone,

Can you tell me how to calculate what next week's date will be? For example the date is Thursday 7-Sep-2006 and I would like to claculate it to be Thursday 14-Sep-2006 I would also like to use the same technique for next month or next year etc.

Thanks.

Emad

 

[northman]

If you define a field NewDate as long, here is a solution

! New Week
NewDate = Date(Month(Today()),Day(Today())+7,Year(Today()))
!End

! New Month
NewDate = Date(Month(Today())+1,Day(Today()),Year(Today()))
!End

! New Year
NewDate = Date(Month(Today()),Day(Today()),Year(Today())+1)
!End

Hope this helps

Serge

 

[rleiman]

Hi Serge.

Wow. That was fast!

That code is what I was looking for. Thanks.

Truly,
Emad

 

[MarkGoldberg]

Hi Emad,


NextWeek = TODAY() + 7
NextMonth = DATE( MONTH(TODAY()) + 1, DAY(TODAY()), YEAR(TODAY())
NextYear = DATE( MONTH(TODAY()), DAY(TODAY()), YEAR(TODAY()+1)

Date % 7 ! % is the MODULUS operator
0 -> Sunday
1 -> Monday
...
6 -> Saturday

Note: CW's DATE command handle values outside of the normal range.
So DATE( 13, 25, 2006) = DATE( 1, 25, 2007)

HTH,
-- Mark

 

[rleiman]

Hi Mark,

Thanks for your code as well as the code from Serge.

I will be using your Date % 7 because I need to check wether the date the user enters is on a Thursday. Thanks.

It's all very helpfull.

Truly,
Emad