Converting Excel Date
I'm trying to convert a date stored in excel to the format, dd-mmm-yyyy
I've managed to get the formatting sorted but am unable to get this too work using database fields.
[code]
abc = "01/02/2012"
Value = Left((abc), 2) & "-" & MonthName( Right(Left((abc), 5) , 2),2) & "-" & Right((abc),4)[/code]
How can i can i convert the database field (in number of days) in to the format dd/mm/yyyy for starters?
I have tried and failed using the FormatDateTime function with no luck.
Regards
TG
I've managed to get the formatting sorted but am unable to get this too work using database fields.
[code]
abc = "01/02/2012"
Value = Left((abc), 2) & "-" & MonthName( Right(Left((abc), 5) , 2),2) & "-" & Right((abc),4)[/code]
How can i can i convert the database field (in number of days) in to the format dd/mm/yyyy for starters?
I have tried and failed using the FormatDateTime function with no luck.
Regards
TG
0
-
I'm not sure I understand your question. I assume your VB script example gives you the formatted date that you want? What then are you trying to convert what into what? Your question isn't clear to me. 0 -
Hello,
How can I convert date to special numbers. I have excel sheet with dates and specific numbers, but I do not know how to set in Datamatrix that the specific numbers will change acc. to current date.
0
請登入寫評論。
評論
2 條評論