[MS_AccessPros] Manipulate date in query

 

I have a query that we need to show a value of the value of the date + 365

The value that we are having trouble with is that the field has the value of 1/1/1900. I have the below expression but I don not know how to put the system date in the IIf statement. Can anyone help with this?

End Date: IIf([Earnings End Dt]=#1/1/1900#,DateAdd("d",365,[Earnings End Dt]))

Thank You

 

Jim Wagner

---

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___