Type mismatch

[JeroenDortmans]

I have a Access database which has a table with a field "Tijdstempel". This field is a "date / time" field. When this filed isn't empty this code works fine.

<%
Tijdstempel_connector = FP_FieldVal(fp_rs,&quot;Tijdstempel&quot
Tijdstempel_connector2 = Day(Tijdstempel_connector) & &quot;/&quot; & Month(Tijdstempel_connector) & &quot;/&quot; & Year(Tijdstempel_connector)
%>
<% Response.Write &quot;Last modified: &quot; + Tijdstempel_connector2 %>

When this field is empty I get the error message Type mismatch: 'Tijdstempel_connector'.
How can I solve this.

 

[Cheech]

use an if statement to check if the filed is greater than &quot;&quot; The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)

 

[JeroenDortmans]

Same resolt when I use this code:

<%
Tijdstempel_connector = FP_FieldVal(fp_rs,&quot;Tijdstempel&quot
If Tijdstempel_connector > &quot;&quot; Then
Tijdstempel_connector2 = Day(Tijdstempel_connector) & &quot;/&quot; & Month(Tijdstempel_connector) & &quot;/&quot; & Year(Tijdstempel_connector)
End If
%>

 

[Ladyhawk]

Shouldn't it be ...

If Tijdstempel_connector <> &quot;&quot; Then

instead of

If Tijdstempel_connector > &quot;&quot; Then

Ladyhawk.
** ASP/VB/Java Programmer **