M momoko Registered User. Local time Today, 04:05 Joined Oct 7, 2001 Messages 41 Sep 9, 2002 #1 Hi, I have a comparsion in month, for example : Dim Test as string Test = "Aug2002" if test = format(date, "mmmyyyy"). ' this will only get the current month, how can I get the previous month? Thanks,
Hi, I have a comparsion in month, for example : Dim Test as string Test = "Aug2002" if test = format(date, "mmmyyyy"). ' this will only get the current month, how can I get the previous month? Thanks,
J Jon K Registered User. Local time Today, 04:05 Joined May 22, 2002 Messages 2,209 Sep 9, 2002 #2 It is:- Format(DateAdd("m", -1, Date), "mmmyyyy")
