Date Formula

[DirtyB]

Can anyone help me get started writing a date formula? I have a SQL Field (datetime datatype) that stores the date something happened (called ActionDate). I need on my Crystal Report the ActionDate and then the date of the following Saturday. The ActionDate could be any day of the week. So for example, if my ActionDate is 9/12/2001 438p.m. then I need a formula that returns 9/15/2001. Any help is much appreciated.

Thanks

 

[FoxG]

Hi,

You should be able to do this with a simple formula...

numbervar d := DayOfWeek ({datetime_field});
datevar dt := date(datetime_field}) + (7-d);
totext(dt,"ddd yyyy/MM/dd&quot

PS. I have tested it !!

Geoff

 

[FoxG]

Hi,

PPS. I should have declared the variables as local !!

Geoff

 

[DirtyB]

Geoff:

THANK YOU! Thank you so much. I have seen the DayofWeek function before but I couldn't find much on how to use it. Just for future references, it will return a 1 for Sunday and a 7 for Saturday then right?