Full Version: How to identify dates from text boxes?
UtterAccess Forums > Microsoft® Access > Access Date + Time
gHuLzEr
Hi guys!
I have a table that stores an abbreviated date in the form of a text field for reference. Data in this field would be for example "January 1" . Is there any way I can use to be able to check whether this date is equal to the current date? I had an idea like maybe:
CODE
If [TextAbbrevDate] LIKE Month(Now()) Then .....

Am i too naive to think this would work? Thanks for any assistance given!
Regards,
Tajul
R. Hicks
I can't say that I agree with your method of data storage ... but try:
!--c1-->
CODE
If Me.TextAbbrevDate = Format(Date, "mmmm d") Then

RDH
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.