>Thanks but in British Data format the syntax would be same?
>
>Saify
That is why I love DATE() and DATETIME() functions, no matter what is your SET DATE parameters they accept are always in the same order and ALWAYS return valid date or datetime value.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.