P PK2005 New member Local time Today, 19:16 Joined Sep 13, 2005 Messages 2 Sep 13, 2005 #1 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
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
S ScottGem Registered User. Local time Today, 14:16 Joined Jun 20, 2005 Messages 1,119 Sep 13, 2005 #2 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.
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.
