I am trying to get MonthName to give me the previous month by doing this: MonthName((DatePart"m", Date(), 1)-1) but I am getting an illegal procedure call or argument error message. Can anyone help me with the syntax or can I even do this? Thanks.
casox


Reply With Quote
