I need to return only date and month in a field that now returns month, day and year. Thanks folks.
S Sokan33 Aug 16, 2005 #1 I need to return only date and month in a field that now returns month, day and year. Thanks folks.
O Ofer Aug 17, 2005 #2 To return day and month from a date field you can use Format(DateField,"dd/mm") Or Format(DateField,"ddmm") Or Day(dateField) return the day Month(DateField) return the month Or datepart("m",DateField) to return the month datepart("d",DateField) to return the day
To return day and month from a date field you can use Format(DateField,"dd/mm") Or Format(DateField,"ddmm") Or Day(dateField) return the day Month(DateField) return the month Or datepart("m",DateField) to return the month datepart("d",DateField) to return the day
