Time

[evansabres]

Hello -

In my application, I am trying to utilize a list box to display appointment times.

My data source displays the time in the following format: hh:mm:ss TT. (For example, 2:30:00 PM)

However, when I bring the data into my Qlik application, it displays in a 24 hour format (2:30 PM becomes 14:30)

How can I have this display as 2:30 PM in my application?

Thank you.

[sunny_talwar]

Check if your time format is set like this within QlikView:

SET TimeFormat='h:mm:ss TT';

And then may be this:

Time(TimeField) as TimeField,

[evansabres]

My Set TimeFormat is set up like that, however, still get the same results when I reload the ap.

My Field is Time' and the format it appears is HH:MM:SS AM/PM

Just want to make sure I explained this fully.

Thank you.

[sunny_talwar · Accepted solution]

Try going into document properties (Alt +Ctrl + D) and set the TimeField format from there for the whole application and see if that helps.

[evansabres]

worked perfectly, thank you

[sunny_talwar]

Awesome