mcerk Posted December 26, 2004 Posted December 26, 2004 hm... this is strange. If I insert Date.Now into SQL database 'datestamp field', and then try to retrieve it with reader like Lebel1.text = Format(myReader("field1"), "dd.mm.yy") I dont get correct value. Days and years are ok, but months are complete wrong. What is the problem? (mm can allso be bigger than 12 like 59 or something). I'm confused.... Quote
*Experts* Nerseus Posted December 26, 2004 *Experts* Posted December 26, 2004 Check the help on ToString for dates, mm is miliseconds I think. You want MM instead - it's case sensitive. -ner Quote "I want to stand as close to the edge as I can without going over. Out on the edge you see all the kinds of things you can't see from the center." - Kurt Vonnegut
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.