Adding days to date 2

[angels2]

I do not know if this can be done I am pulling my information from an as400 db2 into a table then running a query and want to ad 1 day to a date field which is no problem except for Friday I need to add 3 to bypass Sat and Sun and move Friday's date to Monday is this possible?

 

[SkipVought]

Hi,
[tt]
[MyDate]+iif(Format([Mydate],'ddd')='Fri',3,1)
[/tt]


Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[PHV]

Newdate: [date field] + IIf(Weekday([date field])=6, 3, 1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

Skip, your suggestion is highly dependant on locale...

 

[SkipVought]

True.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}