Skip to main content
Question

Javascript time calculations in custom reports aka more problems using rest api as a dataset

  • April 3, 2025
  • 1 reply
  • 31 views

christopherlecky
Explorer
Forum|alt.badge.img+16

So, 

I am creating a report to capture events across time.

The problem is that the daterange input control returns time as a UTC string, but the api wants epoch time.

The input looks like this, and it passes the correct data but 

 

I tried just sticking Date.parse in there, but it didn’t work.

 

 

Is there a way to massage the output of the controls before using them as inputs?

With sql as a data source you can handle it all the query.

Can someone tell me what I am missing?

 

Thanks.

Chris.

1 reply

Forum|alt.badge.img+14

Hello ​@christopherlecky 

EPOCH time is UTC just in a different format. Can we not just use EPCOCH time?

Kind regards
Albert Williams