Jim,
The system date is returned from the Date() function although I'm not sure that is what you mean.
Duane Hookom MVP
MS Access
________________________________
> From: luvmymelody@yahoo.com
>
>
> 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 (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar