D Duane Hookom Dec 3, 2005 #2 Feel free use the large white space below the subject line to enter your question. Take a look at these functions: Mid() Left() Right() CDate() Replace() Just one of many possible solutions is cdate(Replace(YourStringDate ,"_","-"))
Feel free use the large white space below the subject line to enter your question. Take a look at these functions: Mid() Left() Right() CDate() Replace() Just one of many possible solutions is cdate(Replace(YourStringDate ,"_","-"))
J John Vinson Dec 3, 2005 #3 It's considered polite to post your question in the text area, not just the subject line. That said... DateSerial(Left([datestring], 4)), Mid([datestring], 6, 2), Right([datestring], 2)) should do it for you. John W. Vinson[MVP]
It's considered polite to post your question in the text area, not just the subject line. That said... DateSerial(Left([datestring], 4)), Mid([datestring], 6, 2), Right([datestring], 2)) should do it for you. John W. Vinson[MVP]
R Randy Harris Dec 3, 2005 #4 John Vinson said: It's considered polite to post your question in the text area, not just the subject line. That said... DateSerial(Left([datestring], 4)), Mid([datestring], 6, 2), Right([datestring], 2)) should do it for you. John W. Vinson[MVP] Click to expand... John, I think you might have gotten an extra ')' in there. DateSerial(Left([datestring], 4), Mid([datestring], 6, 2), Right([datestring], 2))
John Vinson said: It's considered polite to post your question in the text area, not just the subject line. That said... DateSerial(Left([datestring], 4)), Mid([datestring], 6, 2), Right([datestring], 2)) should do it for you. John W. Vinson[MVP] Click to expand... John, I think you might have gotten an extra ')' in there. DateSerial(Left([datestring], 4), Mid([datestring], 6, 2), Right([datestring], 2))
J John Vinson Dec 4, 2005 #5 John, I think you might have gotten an extra ')' in there. Click to expand... Thanks Randy - quite right! I think it slipped in from the LISP compiler... John W. Vinson[MVP]
John, I think you might have gotten an extra ')' in there. Click to expand... Thanks Randy - quite right! I think it slipped in from the LISP compiler... John W. Vinson[MVP]
T Tolga Uzuner Dec 4, 2005 #6 John said: Thanks Randy - quite right! I think it slipped in from the LISP compiler... John W. Vinson[MVP] Click to expand... Many thanks to everyone for their kind replies, and noted re posting msg into the body of the email. Regards, Tolga
John said: Thanks Randy - quite right! I think it slipped in from the LISP compiler... John W. Vinson[MVP] Click to expand... Many thanks to everyone for their kind replies, and noted re posting msg into the body of the email. Regards, Tolga
