Reformat date

[shannonlp]

Hi,

I need to format the value of a date field to this format:

Jan-00

The date is stored as 01/10/2010.

I think I need to start with the DatePart function but I’m not having any luck.

Any help would be much appreciated.

 

[lbass]

If it is actually a date datatype, you can just right click on it->format field->date-> and select the appropriate format.

-LB

 

[shannonlp]

That was so simple I’m embarrassed for asking. I thought it might be more complicated than that because I need to group on the month-year.

Thanks for your help.

 

[lbass]

For the grouping, you can insert a group on the date and choose to print "for each month".

-LB