DatePart Question

[t5amec]

I have a query that will turn 19/03/2004 to 3.

DatePart("m",[WeekEnd])

That's ok but not what i want.

Firstly I would like it so it would show the first three letters from name of the month, ie MAR. and the year too.

My expertise in DatePart are as advanced as my similie making, and would lead my to editing the above code to:

DatePart("MMM-YYYY",[WeekEnd])

but you guys will know better than I, that this will not work at all.

Please help.

Thanks in advance.

Make Sense? I hope so (-:

 

[SkipVought]

Hi,

How 'bout
[tt]
Format([WeekEnd], "mmm-yyyy")
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[t5amec]

weeee, cheers skip, give yourself a pat on the back



Make Sense? I hope so (-: