Help with dates, queries, and VBA

[Dan2kx]

Bit of a strange one for ya here,

i have table with Day, Month, Year and Weekday codes constructed by a loop that adds one to a recordset to construct a table of dates basically

Day(sdt), month(sdt)...........

sdt = sdt +1

loop until sdt = edt


that works easy

to construct a proper date i am using the CDate formula like so
Cdate([DCode] & " / " & [MCode] & "/ " & [YCode])

Easy right??

i can contruct that in a query and get the query to return the Day code for the date based on a match in a text box.

but i want to run the query in VB so that i can say

If "Value returned" is (weekday number (1-5)) then update other table
else dont

but VB wont accept the "/" and it errors, does anyone know how to write / in VB?

i hope that makes sense

[MikeTheBike]

Bit of a strange one for ya here,

i have table with Day, Month, Year and Weekday codes constructed by a loop that adds one to a recordset to construct a table of dates basically

Day(sdt), month(sdt)...........

sdt = sdt +1

loop until sdt = edt


that works easy

to construct a proper date i am using the CDate formula like so
Cdate([DCode] & " / " & [MCode] & "/ " & [YCode])

Easy right??

i can contruct that in a query and get the query to return the Day code for the date based on a match in a text box.

but i want to run the query in VB so that i can say

If "Value returned" is (weekday number (1-5)) then update other table
else dont

but VB wont accept the "/" and it errors, does anyone know how to write / in VB?

i hope that makes sense

Hi

All very confusing, but if [CDay] etc are numbers for day, month, year, then I would use the DateSerial() function. This is a very powerfull/flexible function for maniputating dates.

Also, why store the individual parts if the date instead of the date itself?
If you store the date you can easily extact the three part using functions. The same applies to the Weekday also (ie WeekDay() function).

If this is way of beam, then pehaps posting the code would help!

MTB