Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help converting number to date
Nevermind, I figured that part out, new code... IIF(IsDate((Val(Left([Comment Date],2)) & "/" & (IIf(Val(Mid([Comment Date],4,2))="0",Val(Mid([Comment Date],3,2)),Val(Mid([Comment Date],4,2))) & "/" & Val(Right([Comment Date],2))))),CDate(Val(Left([Comment Date],2)) & "/" &...- Confusum
- Post #12
- Forum: Microsoft: Access Forms
-
Help converting number to date
Hmm, following your example, here is the code I wrote.. IIF(IsDate((Left([Comment Date],2)&"/"& (IF(val(mid([Comment Date],4,2))="0",mid([Comment Date],3,2),mid([Comment Date],4,2))& "/" & Right([Comment Date],2)),(Left([Comment Date],2)&"/"& (IIF(val(mid([Comment Date],4,2))="0",mid([Comment...- Confusum
- Post #11
- Forum: Microsoft: Access Forms
-
Help converting number to date
Hey Ken, so what if I am trying to do this in Access? I realize now I can't use the CDate function for pass through queries, but how do I convert a string to a date so I can do sorts on it, etc? When I use the CDate function or DateValue function, it appears to create a Date field (if I turn...- Confusum
- Post #9
- Forum: Microsoft: Access Forms
