datepart to show month

[asid]

I know this must be simple…

How do you show the actual month from the results of using the datepart function in a query

Query xMonthatePart("m",[ContractStartDate],[MaturityDate])

I want to show Jan, Feb march not the integer value.

Cheers

 

[pbaldy]

Look at the Format function instead of DatePart.