Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to use the following as a dimension with no luck. What am I missing?
Thanks
time(date(Opportunity.CreatedOn,'YYYY/MM/DD hh:mm:Ss'),'hh TT') as Hour_Created
Example:
12 PM and then counting the number of opportunities created at 12 PM.
Hi Thom,
the trick is to let only the hour part of your timestamp count as a distinct value.
All formatting time functions (time, date, timestamp) do not change the numerical representation of your Opportunity.CreatedOn timestamp and therefore are not sufficient per se.
Therefore you have to round or truncate the timestamp to full hours or extract it's hour part.
Possible solutions are e.g.:
a not functioning example would be:
because this expression does not remove the differences of the minutes part of the timestamp.
hope this helps
regards
Marco
Thanks Marco,
That was exactly what I was looking for.
Thom
You're welcome
regards
Marco
how do i create a hourly list box ?
open a thread and describe your requirements in detail
This is my thread how to create master calender link with bi-hourly time
you have provided a solution, but since i have to join 3 tables and each table has timestamp filed. I am able to create master calender but the issue time. Here is my list box from date and time. I would like to know why iam not getting unique time .