If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Whatever the settings of Windows can be, Access always works with dates in the mm/dd/yyyy (US) format, in SQL as well as in VBA. You can change the way a date/time data will be output (for display, export, print, etc...) by using the Format function:

Code:

Format([DateValue], "dd/mm/yyyy")

Where DateValue is the name of a column (field) in a table or a query.

I'd try something like
iif(NOT isdate(Call1Date),"#01/01/1900#",Call1Date)
you have two separate issues here
Access/JET stores dates as a number of ticks since 31/12/1899, although its default display format is US mm/dd/yyyy or ISO yyyy/mm/dd

the trick isw to make certain that call1date is a date value.. use a date picker or make certain the underlying dataype is datetime

whenever I see a column called something like Call1Date it sends shivers down by normalised spine similar to running fingers down a blackboard.. are you absolutely certain your mode is normalised?