Re: [Emerald] TimeOn page

Josh Hillman ( (no email) )
Tue, 11 Apr 2000 10:27:18 -0400

From: <marcus@redcentre.com>
> We have been using the Tim_on IDC scripts (downloaded from the
> Emerald ftp site). One of the problems with these scripts is that
> the date format (as entered on the Web page) is mm/dd/yy. We require
> dd/mm/yy. Would somebody be able to explain how we change the
> date format over?

CompleteDate = convert(char(8), getdate(), 3) +' '+
convert(char(8), getdate(), 8)
or
CompleteDate = convert(char(8), getdate(), 3) +' '+
convert(char(12), getdate(), 14)

The first line shows the date. The second line shows the time.
If you're pulling a specific date field instead of the current date/time,
replace "getdate()" with "CallDate" or whatever the field is named.

JOsh

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart