Converting Dates Query 2

[Enderjit Singh]

Thanks to Glen and Douglas I sorted out my last query.

My query now is I have set up a module to change the date
format from DDMMYY to YYYYMMDD, but I have got blank
fields in some of the records. How do I get around this
problem?

 

[Ron Weiner]

Take a look at the NZ() function.

Ron W