calculate due date 1

[DLynnTX]

I am sorry to have to post this. I have searched and can't seem to find what I need. I have a Referral Due date and a Referral Received date. I want to add 14 days to whichever date is later as the Due date. This is what I have in my query. What am I doing wrong?

DueDate: IIf([RefEffDate]>[RefReceiptDate],Format([RefEffDate]+14),Format([RefReceiptDate]+14))

I have two records that I'm testing. One has 09/27/2007 for RefEffDate and 09/29/2007 for the RefReceiptDate. The other has the reverse. Both records show 10/13/2007 as the DueDate. It puts the true value in even if it is false.
Thank you for your help.

 

[DLynnTX]

Nevermind... that's a DUH... and I'm way to tired to be doing this.

 

[SkipVought]

Hi,

Why are you using the Format function to return a DATE?

The Format function returns a STRING.
[tt]
DueDate: IIf([RefEffDate]>[RefReceiptDate],[RefEffDate]+14,[RefReceiptDate]+14)
[/tt]


Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[DLynnTX]

Thank you, I made that change. Found the format info on TT and didn't really realize what it was doing or that it would work without it. Thanks again.