'today' condition in set analysis

[evgeniystuchalk]

Hello!

How set 'today' condition in set analysis?

I want to see some measures, related only to current day, without filtering.

This code does nothing.

Count({$<[date]={'=today()'}>} [contactID])

What is wrong?

[sunny_talwar]

Try this:

Count({$<[date]={"$(=Date(Today(), 'DateFieldFormatHere')"}>} [contactID])

Add the date field format in place of this -> DateFieldFormatHere

[evgeniystuchalk]

nope, it gives null as result. tryed today(), tryed integer number - all with same results

[Nicole-Smith]

Does your date have a timestamp?

Count({$<[date]={'$(=timestamp(today()))'}>} [contactID])

[GabrielAraya]

mmm I tested with the following instruction without problems .. Sum({<date={"=Today()"}>} contactID) ..

another point is: What is the format of your date field, Is it Date or Timestamp?

[sunny_talwar]

Check these links to make sure dates are read as dates:

Get the Dates Right

Why don’t my dates work?

And this one to understand how is date used in set analysis:

Dates in Set Analysis

[evgeniystuchalk]

Is solid Date. 'DD.MM.YYYY'

[sunny_talwar]

So this didn't work?

Count({$<[date]={"$(=Date(Today(), 'DD.MM.YYYY')"}>} [contactID])

Also, make sure that date is not Date (with upper case D) or DATE (or all upper case) and same is with all your other fields.

[GabrielAraya]

Can you share your QVW file with few records?

[evgeniystuchalk]

Unfortunately, your formula return null in my case. All syntax is correct, i've double cheked it.