How to isolate the day-value

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

Guest

In a program I am writing I need to isolate the day value from a date. I have
a date on the format dd.mm.yyyy, and need a formula in a query that returns
only the dd value as a number. I.e. from the date 14.05.2005 i need the
result 14. Do anyone have a formula that handles this?
 
The Day function will do this
Day(YourDate) will give you 14
There is also Month & Year functions which will give you the month & year
from a date value.
 
Back
Top