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?

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?

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?

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?

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?

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?