Month/ Date Query

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

Guest

Hi all,
I already have a field in my database with a complete date (month, day,
year) in Date/time format. I'm trying to build an expression in a query to
pull the month from that date and put it in a new field. I've tried fooling
around with the date/ time built in functions with no success. If you have
any ideas or suggestions I'd appricate them greatly. Thanks!
-Ian
 
You can use

--DatePart("M",[Your Date]) to return the month number
--Month([Your date]) to return the month number
--Format([Your Date],"mmm") to return the abbreviated month name
--Format([Your Date],"mmmm") to reutrn the full month name
 
Back
Top