Set analysis Today()

[segerchr]

Post edited by Community Team member:

Please only post in English unless in a dedicated language section.

Translation done by Google translate.

---

Hi,

I'm trying a helpdesk solution by Set Analysis structuring.

Have the following line input:

acTicketErstelldatum is in the data model as: illustrated 41235.46. That is my opinion ok.

Target: All tickets which were created today.

Sum({$<acTicketErstellungsdatum={'date(today()'}>}[#ITTicket_erstellt_Zähler])

Can you help me here in troubleshooting?

Greeting

CS

[MK_QSL]

Sum({$<acTicketErstellungsdatum={'$(=Date(Today()))'}>}[#ITTicket_erstellt_Zähler])

[sunny_talwar · Accepted solution]

May be this:

Sum({$<acTicketErstellungsdatum={"=Num(Floor(acTicketErstellungsdatum)) = Num(Today())"}>}[#ITTicket_erstellt_Zähler])

[swuehl]

Sum({$<acTicketErstellungsdatum={'$(=date(today())'}>}[#ITTicket_erstellt_Zähler])

But your field acTicketErstellungsdatum seems to be a timestamp in fact, so either create a pure date field in the script or try

Sum({$<acTicketErstellungsdatum={">=$(=num(Daystart(today()))<=$(=num(Dayend(today()))"}>}[#ITTicket_erstellt_Zähler])

[segerchr]

Hi,

thanks for your answers. But it doesnt work.

Sum({$<date(acTicketErstellungsdatum)={'$(=Date(Today(),'DD-MM-YYYY'))'}>}[#ITTicket_erstellt_Zähler])

The function date(acTicket... compare with the function Date(Today(),'DD-MM-YYYY' has the similar result.

[sunny_talwar]

This isn't going to work this way. You cannot have Functions (Date()) on the left hand side of the set analysis modifier.

[segerchr]

OK thanks for your answer.

Now i have vToday as a variable declarated, but the code still doesn`t work.

Count({$<acTicketErstellungsdatum={'vToday'}>}[#ITTicket_erstellt_Zähler])

Can you find a another solution ?

Thanks

[segerchr]

count({$<acTicketErstellungsdatum={"=Num(Floor(acTicketErstellungsdatum)) = Num(Today())"}>}acTicketnr)

This was the correkt code. Thanks your answer was right.