selecting month from date field

Results 1 to 2 of 2

Thread: selecting month from date field

  1. #1
    ashumati Guest

    Default selecting month from date field

    i would like to know how to retrive only month from <BR>(dd/mm/year) date formatted field from database.<BR>i am giving a query where user will <BR>select month ,like ( april to june)and query will display all the records from date field where month is may.<BR><BR>this is urgent please<BR><BR>

  2. #2
    Elaine Pack Guest

    Default RE: selecting month from date field

    Not sure if this is what you are asking, but there is a function "datepart" that will pull out the parts of the date:<BR><BR>themonthpart = datepart("m",yourdatefield)<BR><BR>You can also grab the Day ("d") or the Year ("yyyy") or the Julian day (I think) ("y"). The quotes are required.<BR><BR>Hope this helps!<BR>

Posting Permissions

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