thanks - this is very helpful. The other part of the problem is if a
date is entered into the web page as dd/mm/yy - how would I convert
the it to a mm/dd/yy string. This needs to be done prior to passing
the the SQL queries.
Marcus
> 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.
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart