Set Analysis used Variable Date type

[#1]

Hi,

I should cont iun a table(filtering on a range date) how many WELDID thatere are before range selected.

I use

=COUNt({$<DTES_VT = {<$(#FDate2)}>} WELDID)

but i have an error..

Please someone can help me?

many thanks 🙂

[khadeer]

Can u post ur sample data

[alexandros17]

COUNT({$ <DTES_VT = {<'$(FDate2)'}>} WELDID)

Try this but it would be better if you could tell me the error message

[sushil353 · Accepted solution]

Try this

=COUNt({$<DTES_VT = {"<$(#FDate2)"}>} WELDID)

[jonathandienst]

Hi

Assuming that FDate2 is a variable that contains a date value, and DTES_VT is a field containing a date in the default format for your document, then this should work:

Count({<DTES_VT = {"<$(=Date(FDate2))"}>} WELDID)

If FDate2 is a field, then you could use something like

Count({<DTES_VT = {"<$(=Date(Max(FDate2)))"}>} WELDID)

But your mileage will depend on your data model. I suggest that if these two don't work, that you post your document or at least a sample.

Regards

Jonathan

[#6]

thanks everybody 🙂

i missed the " char to open and close the condition!

many thanks and best regards!