[AccessD] Date Format for Month

Check for null first

If not IsNull(datenextsai) Then
	If Month(DateNextSAI) = Month(Date) and Year(DateNextSAI) =
Year(Date) Then . . .

	endif
endif

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis,
Virginia
Sent: Monday, February 05, 2007 12:16 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Date Format for Month


Error if DateNextSAI is null. Which is possible if the equipment hasn't
been inspected yet.
 
Virginia
 
*********************
 
How about
 
If Month(DateNextSAI) = Month(Date) and Year(DateNextSAI) = Year(Date)
Then . . .
 
Jennifer
 

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com