I'm sure this is easy. I have a log with with start and end times of a scheduled process and want to show the duration as well.
3 attributes:
Log_Sync_OIP.Sync_OIP_Duration
Log_Sync_OIP.Nbr_OIP_Sync_End
Log_Sync_OIP.Nbr_OIP_Sync_Start
Softball question: How to calculate duration
Softball question: How to calculate duration
Tom - V8.8 build 3137 - MySql / PostGres
Re: Softball question: How to calculate duration
Duh ,,, I was using the wrong beginning & ending attributes. I was using a couple of beginning & ending integer record counters instead of my timestamp attributes.
Log_Sync_OIP.Sync_OIP_Duration=Log_Sync_OIP.Sync_OIP_Ended_ts-Log_Sync_OIP.Sync_OIP_Started_ts
Even though I have _ts suffixes on my timestamp attributes to make them stand out as such.
Log_Sync_OIP.Sync_OIP_Duration=Log_Sync_OIP.Sync_OIP_Ended_ts-Log_Sync_OIP.Sync_OIP_Started_ts
Even though I have _ts suffixes on my timestamp attributes to make them stand out as such.
Tom - V8.8 build 3137 - MySql / PostGres