Hi

Sorry if sometihng similar has been posted.

But all I want to do is get this to return data that is a month from now

Gate: IIf(Format([7 PDB],"mmyy")=Format(Date(),"mmyy"),"Move to Delivery")

Any help appreciated

PK

Is 7 PDB a date field? If it is why check its format?

=DateAdd("m",1,[datefield])

will add one month to the date in datefield. If you want to format that date to only display mmyy that's a separate issue.