Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jeroenlansberge
Contributor III
Contributor III

Using Today() function for a field

Ls,

I want to use the Today() function to show textual notifications (field name: [Report]). There are a lot of explanations for Count, Sum etc with Today() but i dont need to sum/count something just show notifications made today.

=[Report] if (<{DayStart=(Today())}>) or something like this????

 

Thank you in advance for any help!

Labels (2)
5 Replies
sunny_talwar

Do you only have a single Report value for every DayStart? If you do, try this

Only({<DayStart = {"$(=Date(Today()))"}>} Report)
jeroenlansberge
Contributor III
Contributor III
Author

Dear Sunny,

For some reason this does not seem to work. The field contains text lines which can very in amount every day. It is data processed by an app. People can make a notification about a situation. So one day there can be 1 notification and the other day maybe 10. I have included an example (see file).

In simple terms : show me the reports which are sent with today's date

Could you pls have a second look? really appreciated!

Kr Jeroen

sunny_talwar

And show them where exactly? In a KPI object or a chart?

jeroenlansberge
Contributor III
Contributor III
Author

Dear Sunny,

Either in a table or text box, thx

sunny_talwar

Can you check if this works

Concat(DISTINCT {<DayStart = {"$(=Date(Today()))"}>} Report, ', ')

If it doesn't, would you be able to provide a sample to show what you have and what you expect to see as the output?