Set Analysis with today()

[#1]

Hello all,

I am trying to return the widgets_purchsed for yesterday, but am getting errors. Can someone point me in the right direction?

=Count( {1<SESSION_START_TIME = {$(=Date(Today()-1, 'MM/DD/YYYY'))}>} widgets_purchsed )

[PrashantSangle]

Hi,

Try with ""

like

=Count({<SESSION_START_TIME = {"$(=Date(Today()-1, 'MM/DD/YYYY'))"}>} widgets_purchsed )

Check your Session_start_Time format.

Regards

[jonathandienst · Accepted solution]

Hi

Does SESSION_START_TIME contain a time portion? If so, it will (almost) never be equal to Today(). The best solution is to split the time portion out from the date to create a proper date field during the load:

     LOAD

          ...

          Date(Floor(SESSION_START_TIME)), 'MM/DD/YYYY') As SESSION_START_DATE,

          Time(Frac(SESSION_START_TIME)) As SESSION_START_TIME,   // if you need the time portion

          ...

Now use  SESSION_START_DATE in your set expression.

HTH

Jonathan

[#4]

Thanks!