Producing a new date depending on a figure

#1 (**permalink**) 18-Nov-2005, 13:59 PM

I need to make a query which will update a second date field in a main table.
for example The date an order was origanaly taken + 14 days if a customers
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7637-producing-a-new-date-depending-figure.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7637
fee is Â£50
so date order taken is 11/11/05 the re call date would need to be 25/11/05

ii the order is Â£100 re check date needs to be 31 days after origanal order
date.

Any ideas or suggestions would be greatly appreciated

*

#2 (**permalink**) 18-Nov-2005, 13:59 PM

Paul:

The following UPDATE query is one alternative for accomplishing something
like this:

UPDATE MyTable
SET MyTable.SecondDate =
IIf([FeeField]=50,DateAdd("d",[OrderDate],14),IIf([FeeField]=100,DateAdd("d",[OrderDate],31),Date()));

In this example, I defaulted the second date to the current date if the fee
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7637
is not 50 or 100. You can adjust this to your needs. The above query will
update all records. If you want to update only a subset of records, use an
appropriate WHERE clause.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.

"Paul T" T@discussions.microsoft.com> wrote in message
news:C6B1DE20-304C-406E-83FA-5BF3294089A1@microsoft.com...
I need to make a query which will update a second date field in a main
table.
for example The date an order was origanaly taken + 14 days if a customers
fee is £50
so date order taken is 11/11/05 the re call date would need to be 25/11/05

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7637
ii the order is £100 re check date needs to be 31 days after origanal order
date.

Any ideas or suggestions would be greatly appreciated