Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Does VBA have any functions that convert date strings such as M/D/YY, MM/D/YY, or M/DD/YY to MM/DD/YY format?
For example, if sDate == "1/9/19", then the output should be sDate = "01/09/19" The key is that the output date should be in 2-digit month, day and year format, separated by forward slashes. i.e "MM/DD/YY" - Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting Julian Dates to regular dates | Excel Worksheet Functions | |||
Converting Dates | Excel Worksheet Functions | |||
Converting Text dates into dates | Excel Programming | |||
Converting Dates | Excel Programming | |||
converting dates | Excel Programming |