date variable as dCount criteria

[Yatzek]

hi,


where is the mistake:

vSth = DCount("idEx", "t_Workout", "[t_Workout].[ExDate] = #" & dDefaultDate & "#")

where of course [exDate] is date type field and dDefaultDate is date type variable.
i thik, i've tried everythig and still got an error message,
please help me...
what is the right syntax??
thanks in advance,

[ranman256]

DCount("*", "t_Workout", "[ExDate]=#" & dDefaultDate & "#")

dDefaultDate MUST be a date (not null)

[Yatzek]

still syntax error.

here is full code:

dDefaultDate = Date


Do While DCount("*", "t_Workout", "[ExDate] = #" & dDefaultDate & "#") <> 0
dDefaultDate = dDefaultDate + 1
Loop

i'm pretty sure dDeafaultdate is not null,

[Yatzek]

ok, i've solved it!
there was a problem with date format

correct syntax:
...
Do While DCount("*", "t_Workout", "[ExDate] = #" & Format(dDefaultDate, "mm\ / dd \ / yyyy") & "#") <> 0
...