RE: Engagement away from home

[abh12345]

It does the job :)

Thanks for the tip on dates. I usually take the day month year out of timestamp/created and build my own date - much easier when exporting to excel I find.

select
cast(day(timestamp)as varchar(20)) + '/' + cast(month(timestamp)as varchar(20)) + '/' + cast(year(timestamp)as varchar(20))

Comments

[arcange]

If you plan to export a date part to Excel, better (and faster) to use CONVERT(DATE,timestamp)

[abh12345]

That works, cheers :D

[arcange]

Your SQL skills, improved they are now!