| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VB - copying formatted dates programatically
I am assuiming you have an actual date and not a string to be converted.
dim strDate as string strdate = format(range("A1").value, "yymmdd") -- HTH... Jim Thomlinson "Glenn" wrote: I have a date field with "yymmdd" format. I want to programatically convert that to text that looks identical to the formatted date for use in dimensioned variables/strings. e.g. - date 6/10/2008 formatted looks like "080610". I want to use a/the text string "080610" for various other uses. Can anyone help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel VB - copying formatted dates programatically
Many thanks - I found a longer way involving month, day, and year functions,
but this is clean. Yes, I have an actual date. thanks gain..... "Jim Thomlinson" wrote: I am assuiming you have an actual date and not a string to be converted. dim strDate as string strdate = format(range("A1").value, "yymmdd") -- HTH... Jim Thomlinson "Glenn" wrote: I have a date field with "yymmdd" format. I want to programatically convert that to text that looks identical to the formatted date for use in dimensioned variables/strings. e.g. - date 6/10/2008 formatted looks like "080610". I want to use a/the text string "080610" for various other uses. Can anyone help? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel VB - copying formatted dates programatically
If you format the date in the approproately in the spreadsheet the you could
just use dim strDate as string strdate = range("A1").text -- HTH... Jim Thomlinson "Glenn" wrote: Many thanks - I found a longer way involving month, day, and year functions, but this is clean. Yes, I have an actual date. thanks gain..... "Jim Thomlinson" wrote: I am assuiming you have an actual date and not a string to be converted. dim strDate as string strdate = format(range("A1").value, "yymmdd") -- HTH... Jim Thomlinson "Glenn" wrote: I have a date field with "yymmdd" format. I want to programatically convert that to text that looks identical to the formatted date for use in dimensioned variables/strings. e.g. - date 6/10/2008 formatted looks like "080610". I want to use a/the text string "080610" for various other uses. Can anyone help? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel VB - copying formatted dates programatically
What I love about VB is there are often many ways to skin the cat. Thanks
again for your insight and options. "Jim Thomlinson" wrote: If you format the date in the approproately in the spreadsheet the you could just use dim strDate as string strdate = range("A1").text -- HTH... Jim Thomlinson "Glenn" wrote: Many thanks - I found a longer way involving month, day, and year functions, but this is clean. Yes, I have an actual date. thanks gain..... "Jim Thomlinson" wrote: I am assuiming you have an actual date and not a string to be converted. dim strDate as string strdate = format(range("A1").value, "yymmdd") -- HTH... Jim Thomlinson "Glenn" wrote: I have a date field with "yymmdd" format. I want to programatically convert that to text that looks identical to the formatted date for use in dimensioned variables/strings. e.g. - date 6/10/2008 formatted looks like "080610". I want to use a/the text string "080610" for various other uses. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If a range of cells in Excel are formatted as dates ie. (mm/dd/yy) | Excel Discussion (Misc queries) | |||
| copying part of a cell's contents (formatted as dd:hh:mm) | Excel Worksheet Functions | |||
| Programatically copy cells with dates | Excel Programming | |||
| Dates in Excel - yyyymmdd, not formatted, how do I format this? | Excel Discussion (Misc queries) | |||
| Copying Formats vs Formatting Programatically | Excel Programming | |||
Hybrid Mode
