Solved: hours in AM/PM - Qlik Community

Report Inappropriate Content · ‎2014-10-17

Dear All,

I have to create hours from date and then want to show hours in AM/PM..

Hour(date) as Hours

resuult is 11,1,12...but I want 11AM,12PM...etc

What to do plz reply..

Rahul

tresesco · ‎2014-10-17

Try:

Mod(Hour(DateTimeField),12)&' '&time(DateTimeField, 'TT') as Hour

Hope, there is an easier way and not just striking.

View solution in original post

PrashantSangle · ‎2014-10-17

Hi,

Use

Time(Date,'hh TT')

or

Timestamp(Date,'hh TT'))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-10-17

its give 11:22:01 AM format...but I want 11AM(which includes time from 11 to 11:59:59)...

PrashantSangle · ‎2014-10-17

Hi,

Try this in your text Obejct

Time(now(),'hh TT')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

jyothish8807 · ‎2014-10-17

Hi Rahul,

time(Date,'hh TT')

It will give 11 AM as output.

Regards

KC

Best Regards,
KC

Report Inappropriate Content · ‎2014-10-17

dear max,

its give result 11am,11am,3pm,3pm....... but I want result having distinct hours ... 11am,3am,4pm...

Report Inappropriate Content · ‎2014-10-17

My required result is shown in attachment ...

It should be 1AM,1PM,3AM,3PM...but not 1AM,1AM(REPEAT)...

tresesco · ‎2014-10-17

Try:

Mod(Hour(DateTimeField),12)&' '&time(DateTimeField, 'TT') as Hour

Hope, there is an easier way and not just striking.

Report Inappropriate Content · ‎2014-10-17

As always ...you are too good tresesco... thanks..