Hi all,
in my text box the user enters a date value, normally, it could be
5-5-99.
i need it to be changed to 05/05/99..how do i do it..
Urgent..Answer ASAP.
Thanx.
Venkat.
------------------
[email protected]
ICQ: 45714766
http://venkat.iscool.net
Printable View
Hi all,
in my text box the user enters a date value, normally, it could be
5-5-99.
i need it to be changed to 05/05/99..how do i do it..
Urgent..Answer ASAP.
Thanx.
Venkat.
------------------
[email protected]
ICQ: 45714766
http://venkat.iscool.net
Hi,
You can use the format function.
example
dim MyDate
Mydate = Now()
Mydate = Format(MyDate, "dd/mm/yy")
Msgbox MyDate
R@emdonck
Thanx..but it does not formats the date "5/5/99" to "05/05/99"
Any alternates.
------------------
[email protected]
ICQ: 45714766
http://venkat.iscool.net
Venkat
why are all your questions Urgent..Answer ASAP?
You must be very stressed!
debug.print Format("5-5-99", "dd/mm/yy")
the date format functions are dependant on the Regional settings so your output may be different to other peoples
------------------
Mark Sreeves
Analyst Programmer
[email protected]
A BMW Group Company
Hi,
What Mark wrote is true, because the code works on my PC.
My regional setting for short date = "d/MM/yy"
See ya
Hi Mark,
thats true..I used vb-world not only to learn but also as a helper to my project....My project leader is kinda person who is more concentrated in punctuality in finishing the work..If i do not get the thing done within the time, GOD..I will be sacked out..
Thanx man and thanx to R@emdonck.
Regards,
Venkat.
------------------
[email protected]
ICQ: 45714766
http://venkat.iscool.net
Hi, there. This should work:
Format(MyDate, "DD/MM/yy")
Larisa
Hi people,
thanks and it worked after chaning the format of date in the control panel..
regards,
venkat. :)
------------------
[email protected]
ICQ: 45714766
http://venkat.iscool.net