Lookout

cancel
Showing results for 
Search instead for 
Did you mean: 

Date format display in experssions

Solved!
Go to solution

Dear Experts,

I am trying to use an expression in order to display text, integer number and Date format number, this result is “Daily KV MAX is 33.21 kV @ 42189.4” but I need display last number in date/time format and I expect like this “Daily KV MAX is 33.21 kV @ 09:38”, How could is fixed?

 

Thanks in advance

Danesh

 

Ps: this is my Expression, “"Daily KV max is"&..\Kv_daily_max&"kv @"&..\kv_daily_max_time”

0 Kudos
Message 1 of 3
(4,774 Views)

Have you tried using the text function?

 

""Daily KV max is"&..\Kv_daily_max&"kv @"&text(..\kv_daily_max_time,"dd/mm/yyyy hh:ss")"

 

The text function can use any string available to a numeric display.

Message 2 of 3
(4,468 Views)
Solution
Accepted by topic author Danesh

Excellent, it is solved!

0 Kudos
Message 3 of 3
(4,443 Views)