Count on a table, filtering by date and time is a variable

[#1]

Hi, I have a problem that does not make me the count and not to do wrong,

by the variable, vToday as Today

LET vToday = Today ();

statement:

= Count ({<DATE = {$ (= [vToday])}>} CANTIDADPREPARADA)

and gives me "Error: Error in set list element modifier ad hoc ',' or ')' expected.

Many thanks in advance.

Oscar

[sunny_talwar]

Try this instead:

=Count ({<DATE = {'$ (vToday)'}>} CANTIDADPREPARADA)

[sunny_talwar]

If this doesn't work, then you might have to format today in your variable

LET vToday = Date(Today());

HTH

Best,

Sunny

[#4]

ok, perfect, thankssssssssssssssssssssssss

[sunny_talwar]

No problem