I've been messing around with this date thing,
To illiminate client regional settings date must be formatted in code, and I've sussed that its case sensitive
ie:
ToDate('" & StartDateTime & "', 'dd/MM/yyyy HH24:MI:SS')
Will fromate a date day/month/year and 24Hr Time
ie "25/09/2000 18:46:33"
Cheers for all the tips everyone!
Nice1
Skeen.




Reply With Quote