format date field

[bodmin]

I need to output the date field that is stored in the format, dd/mm/yyyy, it needs to be output in the following format yyyymmdd without any punctuation. I have tried to use the format function with the following command,

Print #1, Format(rs("ProducedDate"), yyyymmdd);

but the output remains in the original storage format, any help would be much appreciated.

 

[lupins46]

Print #1, Format(rs("ProducedDate"), "yyyymmdd");

 

[telephoto]

var1=left(date,2)
var2=mid(date,4,2)
var3=right(date,4)

outputdate=var3 & var2 & var3

SOunds too simple?

Telephoto

 

[bodmin]

Cheers lupin that fixed I thought it must be something like that