Use the datePart function
DatePart("m",date_added) will return the integer of the month in date_added (a
datetime field)
Use this to either construct a string that you then convert to a date, or three fields
(day, month, year) that you apply three order criteria on.
Make sense?
>Hi,
>
>I have a table with a date/time field in an Access database.
>I want to have a query grouped on the date, with no regard to time, so
>that all records from the
>same day are grouped.
>I need a function (in SQL-Access) that will extract the day part of a
>date/time value, in a form
>that is still suitable for sorting,
>and I connot find any one.
>
>I tried LEFT(mydate, 8), but it generates a date like mm/dd/yy not
>suitable for sorting.
>What I need is the date of the day in true date format, not as a
>string.
>
>Any idea ?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
