Current hour

[#1]

Hi, how do I display a current hour in a textbox? like displaying a current dat using =Today()

[nilesh_gangurde]

Use the Now() Function in text object .

=Now()

Or

=Time(Now())

Regards,

Nilesh Gangurde

[#3]

Hi Nilesh

I am struggling to get what I needed going, Can you please help me with this, I want to display in a table everything that happen in the past hour from now, please see the file attached.

Regards Edzi

[Jason_Michaelides]

Here's an answer BUT make sure you heed the warnings on use of Now() !!

Now()-(1/24) will give you the current time minus an hour so your dimension variable could be:

If(Yourtimestamp>=(Now()-(1/24),Test_Name)

This should work, but Now() will poll the operating system every second to get the current time. With large data sets dependent upon the result of Now() and with many users you could significantly impact server performance.  Could you not use Now(0) instead?  This will use the datetime the script was last run and would not impact the server in the same way.

Hope this helps,

Jason

[#5]

Hi Jason

I have used the code below but still it doesn’t give return data for the past our, Please help.

IF(text(date(Test_Date1,'YYYY/MM/DD')) = Date(Today(), 'YYYY/MM/DD') and hour(Test_Date1) >= (Now()-(1/24)),Test_Name)

Regards

Edzi

[Jason_Michaelides · Accepted solution]

I think you're over-complicating it a bit!  See attached which uses a variable vFiltertime to define the minimum datetime.  The chart expression then uses this in set analysis rather than using IF statements in a dimension.

Hope this helps,

Jason