>I need to get the Month of a date as word format.
>Eg: if Month(Date) will return "7" (stands for July).
> but I want it to return "July" as instead of "7".
Try MonthName(Month(Date)). You can also pass in an optional parameter to return the month abbreviation MonthName(Month(Date),True).
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao