Dear Don,
Is Text() SQL function? I understand it is Excel function
to format date. What I want is in the SQL query
to return MonthName instead of date like
Select MonthName("01/01/2006") from orders
result I want is "Jan". Pls help.
Regards,
Rakesh
"Don Guillett" wrote:
[Quoted Text] > OR this might be better
> =text(yourdate,"mmm")
>
> --
> Don Guillett
> SalesAid Software
> dguillett1[ at ]austin.rr.com
> "Rakesh Parekh" <RakeshParekh[ at ]discussions.microsoft.com> wrote in message
> news:1EEB684F-DB06-4C5A-B6ED-79F6CA113A6F[ at ]microsoft.com...
> > Dear Sir,
> >
> > I am using a date field in Microsoft Query in Excel 2003.
> > I want the query to return MonthName instead of date. the
> > Query is: Select MonthName(Order_Date) as Date from ORDERS. I
> > have also tried CMonth Function but I am not able to return
> > only the MonthName from date value. Function Month() works but it
> > gives month in numbers like 1,2 3 but I want in Jan, Feb, Mar etc.
> > Can you please help. Where can I see list of functions supported by
> > Microsoft Query.
> >
> > Thanks,
> > Rakesh
>
>
>
|