Forums

This topic is locked

Date Sorting in a Recordset

Posted 14 Mar 2001 12:54:52
1
has voted
14 Mar 2001 12:54:52 Aaron Jay posted:
I am building an online timesheet for internal use, and i want to display a timesheet, but display the records by the week. How would I sort and order my details from Monday to Sunday, and have it based on the current week? I would guess that the work is mostly done in the recordset, but I don't think it can be done within the realm of Ultradev. Will this take some custom scripting?

Replies

Replied 14 Mar 2001 23:32:13
14 Mar 2001 23:32:13 George Petrov replied:
The sort on date parts (week, day of the week) is usually done in the SQL query.
So when you have a Recordset in UD - you should go to advanced view, and change manually the query to contain some date sorting functions like DATEPART

For example:

SELECT ... WHERE ... ORDER BY DATEPART(wk,date_field) ASC

will sort your records asceinding by week number
Look at msdn.microsoft.com for more info on the DATEPART function.

Greetings,
George Petrov
www.UDzone.com

Reply to this topic