7 Replies Latest reply: Jan 28, 2016 4:33 AM by Christian Seger

# Set analysis Today()

Post edited by Community Team member:

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

---

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

• ###### Re: Set analysis Today()

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

• ###### Re: Set analysis Today()

May be this:

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

• ###### Re: Set analysis Today()

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

• ###### Re: Set analysis Today()

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])

• ###### Re: Set analysis Today()

Hi,

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.

• ###### Re: Set analysis Today()

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