Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change date format to text format
Temp7 = Format(temp4, "yyyy")
Temp8 = Format(Left(MonthName(Month(DateAdd("m", -1, Now_ ()))), 3), "mmm") I have a special database formula in VB editor as shown: DBR4(""accounts"",""Retail""," & Temp8 & "," & Temp7_ & ",""EUR"") this formula appears in excel as: DBR4("accounts","Retail",Oct,2003,"EUR")which gives an error because Oct and 2003 are not in "". Temp7 shows up like "2003" and Temp 8 "Oct". To retrieve the right formula in excel, I have to write them like ""Oct"" in VB. But with Temp's I can not do that??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
Macro to Change Changing Date Format Data to Text | Excel Discussion (Misc queries) | |||
how do i change text format date to date (i.e., mm/yy to mm/dd/yyy | Excel Discussion (Misc queries) | |||
CHANGE TEXT TO DATE FORMAT | Excel Discussion (Misc queries) |