I always use this format:

'29-MAY-2006 16:11:27'

Months in English: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT,
NOV, DEC

There is a special date 'NOW' which is, believe it or not, now :-)


Best Regards

Stefan

> Hi,
> in access database i use this DataString value to INSERT a new record,
> for DATE field (taken from a combodata.value)

> DataString = "#" & Format$(ComboData.value, "yyyy/mm/dd") & " 00.00.00#"

> Now in FB2 i receive a conversion error from string
> which is the correct string to pass to insert to correctly insert a DATE value ?

> thanks
> Adriano

--
Stefan Heymann
www.destructor.de/firebird