We help IT Professionals succeed at work.

order query/dbgrid by calculated field

Mike Littlewood
on
Is there a way round trying to order a query/grid by a calulated field holding a date?
Comment
Watch Question

Commented:
Hello Mike

Select Last_Name,Date_Open,(Date_open + as ND From Clients
Order by ND

Best Regards

Cesario
CERTIFIED EXPERT
Top Expert 2004
Commented:
if you calculate the field within your query,
then you can sort,
otherwise not with the standard TDBGrid
mikelittlewood:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
CERTIFIED EXPERT

Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

split points between Cesario and kretzschmar

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Thanks,

geobul
EE Cleanup Volunteer

Explore More ContentExplore courses, solutions, and other research materials related to this topic.