Actually there is two questions that bug me.
1. that will be simple I'm apparantly can't too blind to make out a way to default a datetime column to the equivalent of NOW
2. thats more comestic but ...
SELECT t1.f1, t2.f1 AS 'blub', ....
FROM t1, t2
GROUP BY t1.f1, t2.f1
now I havent yet managed it to display t2.f1 in any other the then format the SQL server like best (2005-07-27 00:00:00) and thats no good .I've tried a CONVERT in the SELECT statement and in the GROUP statement but to no avail any help would be appreciated.
there are always two sides of a story and 12 ways to sing a song or write some code. so whats wrong ?
2. I have never found a solution to this either, so I always just format the date on the receiving end of the recordset when putting it out to a form control or report. Perhaps you can concatenate your own VARCHAR() using each part of the date/time field? For example, in pseudocode:
CAST(<month part> AS VARCHAR(2)) + "/" + CAST(<day part> AS VARCHAR(2)) + "/" + CAST(<year part> AS VARCHAR(4)) etc
I'll try to play around with this a bit and get back to you after lunch