Using an SQL statement to convert date format where the field is NULL???

[Annie D via AccessMonster.com]

Hi,

I am using the following SQL statement courtesy of access monster user:
'Terry Kreft ' to convert dates from a text format (20020331 00:00:00) to a
recognised date/time format (31/03/2002).

SELECT
END_DTTM,
Left([END_DTTM],4) AS END_DTTM_year,
Mid([END_DTTM],5,2) AS END_DTTM_month,
Mid([END_DTTM],7,2) AS END_DTTM_day,
DateSerial([END_DTTM_year],[END_DTTM_month],[END_DTTM_day]) AS
END_DTTM_date
FROM HEORG

This is working very well, however i have come across a problem where the
date field is null. The SQL is trying to serialise the null field, and is
returning: #Error

Can anyone kindly help me write in to this statement, not to convert the null
fields?

Thank you.

Annie
--
Message posted via http://www.accessmonster.com

[pietlinden]

you need to add a filter....

WHERE END_DTTM IS NOT NULL

[lylefair]

how about
WHERE END_DYYM IS NOT NULL

Is Terry Kreft really an Access Monster? I know his work is GIANT! But
....