Hi
I have an userform with a calendar on it, so the user can choose the prefered data. This is saved as a string in the format "mm/dd/yyyy". I would like to save it as a date and with the format "dd/mm/yyyy" instead, but I cannot figure out how. I have tried this:
Please Login or Register to view this content.
Last edited by h0ps; 12-04-2012 at 09:51 AM. Reason: solved
Maybe try
Format(CDate(DateTB.Value), "mm-dd-yyyy") see if that works.
This does the job for 12-28-2012 => 28-12-2012. But for instance 12-07-2012 is kept as 12-07-2012.
Ah I changed the wrong part of the code. Your suggestion solved the problem. Thanks alot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks