Formating Date Field

[Guest]

Hello,

Can I format a date field to show just the first 3 letters of the month - ex
Jan, Feb etc?


also, would I be able to format

=DateAdd("m",-11,Forms!frmSelection!txtEndDate) as the first 3 letters of
the month ?
the txtEndDate is 12/31/2005

 

[Guest]

I am not sure about formatting a field in a table but for everything else:

=Format([YourDateValue],"mmm")

If you also want day and year then:

=Format([YourDateValue],"mmm/dd/yyyy")

Hope that is what you were looking for,

Jim

 

[John Spencer]

If this is a control on a report, then you can set the format property of
the control to MMM
That should show ust the first three letters of the date.