This is the convDate function I use it when a user is typing in a date .

  <%

  'This function recieves a date from text string in format dd/mm/yy or...

1) WHERE (DATEDIFF(d, datelogged, GETDATE()) = 1)

2) WHERE (despatchdate BETWEEN '" & convDate(dteFromDate) & "' AND '" & convDate(dteToDate) & "')

'Using function to massage date.

3) WHERE orderdate > Getdate()...

Try this

CONVERT(Varchar(12),GetDate(),101)

Don't forget to change date type for other countries

REGARDS

Don

Thanks for verifying it,.

Seems a bit of a loose end as far as security.

Don