Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange Values
Hi all,
I am wanting someone to help me with my problem. I have a problem with dates. Dim toDate, fromDate as string toDate = sheets("data").cells(2,5).value fromDate = Sheets("data").cells(2,27).value The problem is that the value for toDate = 1/7/2001 and the value for fromDate = "1/7/2002". How do I take the "" out, I have tried everything? The only difference in the above is the cell reference. Can anyone help or suggestions would be great? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange Values
You have declared toDate as variant, fromDate as string.
You tried everything, so it may be silly to suggest Dim toDate as Date, fromDate as Date but that's what I'd use. Best wishes Harald "Ashman" skrev i melding ... Hi all, I am wanting someone to help me with my problem. I have a problem with dates. Dim toDate, fromDate as string toDate = sheets("data").cells(2,5).value fromDate = Sheets("data").cells(2,27).value The problem is that the value for toDate = 1/7/2001 and the value for fromDate = "1/7/2002". How do I take the "" out, I have tried everything? The only difference in the above is the cell reference. Can anyone help or suggestions would be great? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange Values
Your line
Dim toDate, fromDate As String declares toDate to be a Variant, and fromDate to be a String. Unlike C, the type declaration doesn't apply to the entire line. If you want them both to be dates, try Dim toDate As Date, fromDate As Date In article , Ashman wrote: Hi all, I am wanting someone to help me with my problem. I have a problem with dates. Dim toDate, fromDate as string toDate = sheets("data").cells(2,5).value fromDate = Sheets("data").cells(2,27).value The problem is that the value for toDate = 1/7/2001 and the value for fromDate = "1/7/2002". How do I take the "" out, I have tried everything? The only difference in the above is the cell reference. Can anyone help or suggestions would be great? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange Values
fromDate is dimensioned as String and hence will have the "" whereas todate
is variant by default. Dim toDate, fromDate Dim toDate as String, fromDate as String Dim toDate as Date, fromDate as Date HTH "Ashman" wrote: Hi all, I am wanting someone to help me with my problem. I have a problem with dates. Dim toDate, fromDate as string toDate = sheets("data").cells(2,5).value fromDate = Sheets("data").cells(2,27).value The problem is that the value for toDate = 1/7/2001 and the value for fromDate = "1/7/2002". How do I take the "" out, I have tried everything? The only difference in the above is the cell reference. Can anyone help or suggestions would be great? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange Values
Mate, many thanks, works perfectly. You are a life saver.
Jas "Duke Carey" wrote: don't DIM fromDate as a String. The way your DIM statement reads, toDate is a variant. Cast them both as Date "Ashman" wrote: Hi all, I am wanting someone to help me with my problem. I have a problem with dates. Dim toDate, fromDate as string toDate = sheets("data").cells(2,5).value fromDate = Sheets("data").cells(2,27).value The problem is that the value for toDate = 1/7/2001 and the value for fromDate = "1/7/2002". How do I take the "" out, I have tried everything? The only difference in the above is the cell reference. Can anyone help or suggestions would be great? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange Values
don't DIM fromDate as a String. The way your DIM statement reads, toDate is
a variant. Cast them both as Date "Ashman" wrote: Hi all, I am wanting someone to help me with my problem. I have a problem with dates. Dim toDate, fromDate as string toDate = sheets("data").cells(2,5).value fromDate = Sheets("data").cells(2,27).value The problem is that the value for toDate = 1/7/2001 and the value for fromDate = "1/7/2002". How do I take the "" out, I have tried everything? The only difference in the above is the cell reference. Can anyone help or suggestions would be great? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange | Excel Worksheet Functions | |||
Strange?! | Excel Discussion (Misc queries) | |||
Strange behavior with text box values . . . help! | Excel Programming | |||
2 strange ones.. | Excel Programming | |||
Strange behavior Chart.SeriesCollection(n).Values property | Excel Programming |