topic Set analysis Today() in App Development

Set analysis Today()

segerchr — Fri, 22 Jan 2016 15:01:35 GMT

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

MK_QSL — Fri, 22 Jan 2016 15:07:27 GMT

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

sunny_talwar — Fri, 22 Jan 2016 15:07:46 GMT

May be this:

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

swuehl — Fri, 22 Jan 2016 15:08:19 GMT

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 — Fri, 22 Jan 2016 15:28:03 GMT

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 — Fri, 22 Jan 2016 15:49:17 GMT

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

segerchr — Thu, 28 Jan 2016 09:33:34 GMT

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 — Thu, 28 Jan 2016 10:28:07 GMT

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

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