Convert to a number

ticktack · February 6th, 2004, 08:37 AM

Hi all,
I have been trying to solve the following problem but its seems to be that its not transfering the DayofWeek(Weekday(Now())) numeric value as a number but as a string. I have tried to convert into a number by ising CINT and CDbl but both don't seem to work. Does anyone have any ideas. The script sample is below.

Quote:

quote:

Quote:

DayNumberLoop = DayofWeek(Weekday(Now()))

                If InStr(strdata,DayofWeek(CINT(DayNumberLoop))) = 0 then
                    DayNumberLoop = DayNumberLoop+1
                    If DayNumberLoop > 7 then
                        DayNumberLoop = 1
                    End If
                End If

Thanks
Graham

Use you brain, not your brawn!

pab006 · February 6th, 2004, 10:11 AM

Could you not simply decalre and integer variable and then assign the date value to this, eg intDate = Date()

ticktack · February 6th, 2004, 11:46 AM

Hi pab006,
What do you mean and How can I use it with my current script?
Thanks

Use you brain, not your brawn!

pab006 · February 9th, 2004, 05:30 AM

Sorry i misunderstood, what you where asking, what is this part of your code doing? If InStr(strdata,DayofWeek(CINT(DayNumberLoop))) = 0

I think this part of the code is probably the reason why it is returning a string, would it not be easier to simply test the DayNumberLoop ie if DAYNUMBERLOOP = 0 then ........

sorry for the misunderstanding

pab006 · February 9th, 2004, 05:31 AM

Sorry, have you also tried simply printing out what value is given to to DayNumberLoop?