minus 6 weeks

[Guest]

Hi,

Please help... I have a table of data with Name Address & service Date.

I want to be able to take 6 weeks off the Service Dates.

eg
Name:Mr Smith Add:1 The Street Date:1-Sep-06

In my query how can i make the field Date take 6 weeks off the values so I
can have another field with BroughtForwardDate:15-Jul-06?

Thanks,
Jez

 

[fredg]

Hi,

Please help... I have a table of data with Name Address & service Date.

I want to be able to take 6 weeks off the Service Dates.

eg
Name:Mr Smith Add:1 The Street Date:1-Sep-06

In my query how can i make the field Date take 6 weeks off the values so I
can have another field with BroughtForwardDate:15-Jul-06?

Thanks,
Jez

In my part of the country, Sept. 1st minus 6 weeks is July 21st, not
July 15th.

In a query?
If my memory serves me well, 6 weeks = 42 days.
Add a new column to the query grid:

BroughtFowardDate:[ServiceDate]-42
or you can use:

BroughtFowardDateateAdd("ww",-6,[ServiceDate])

In both cases the value is returned as July 21.

In any case, this value should not be stored in any table.