Order resultset of query by a custom built column [ using dateadd ]

[samvb]

Hi,

I have this query:

SELECT finishtime, bonas, dateadd('s',bonas,finishtime) AS fmore
FROM scores;

It works great but I need to order the result by fmore. It generates errors. Is there anywork around that?

finishtime holds time and differs while bonas is seconds.

[liimra]

Solution/

This should work

SELECT finishtime, bonas, DateAdd('s',[bonas],[finishtime]) AS fmore
FROM score
ORDER BY DateAdd('s',[bonas],[finishtime]);

Regards,
Ali

[samvb]

thank you!

thank you!

u saved my day!

[liimra]

//

Glad it worked for you. Would you kindly mark this post as answered
so it becomes more helpful for others.

Regards,
Ali