Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: Birthdate - need to separate mm dd yyyy

    I have a DOB field and would like to separate the mm dd yyyy in a query (I don't need to store this info separately in a table because I am already storing the DOB itself). Why? I need to run reports for all birthdays in January, or all birthdays in 1989. Hope that makes sense.

    Thanks!!!

  2. #2
    Join Date
    Jan 2004
    Posts
    40
    use the format function

    format(date, "mm") to get the month
    format(date, "yyyy") to get the year
    format(date, "dd") to get the date

  3. #3
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Or how about those beatifull functions
    Month()
    Day()
    Year()

    Maybe Datepart()

    look them up in the access help and pick what you like....

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •