Formating Date Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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.
 
Back
Top