Microsoft KB Archive/198453

= ACC2000: IsDate Returns False with Date in Long Date Format =

Article ID: 198453

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q198453



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you use the IsDate function with a date in Long Date format, the function returns a value of False. For example, the following expression returns a value of False: IsDate("Friday, January 1, 1999") However, the following expression returns a value of True: IsDate("January 1, 1999")



CAUSE
The IsDate function does not recognize days of the week; therefore, it does not recognize a date that is in Long Date format.



RESOLUTION
Do not use a date in Long Date format with the IsDate function. If you want to verify the correct weekday for a particular date, use the Format function to show the weekday. For example, the expression Format("1/10/99","DDDD, MMMM D, YYYY") returns the value

Sunday, January 10, 1999



Steps to Reproduce Behavior
 Start Microsoft Access. Press CTRL+G to open the Immediate window.  Type the following expression, and then press ENTER: ?IsDate("Friday, January 01, 1999") 

The function returns a value of False.

