It is currently 28 February 2021, 3:51 Advanced search

How to set times to show hh:nn am or pm

Questions and answers on how to best use Instant Developer

How to set times to show hh:nn am or pm

Postby bobalston » 27 February 2020, 23:02

How to I specify time to be hh:nn with am or pm designation?

Bob
bobalston
 
Posts: 158
Joined: 26 July 2013, 19:23
Location: Dallas, TX

Re: How to set times to show hh:nn am or pm

Postby ljwilson » 28 February 2020, 17:15

Nothing built-in to inde will do it I'm afraid. I've seen this asked on the Italian side as well.

In theory you could use some well-placed JavaScript to do it, since it is a display issue.

Found the link in Italian Tips & Tricks:
http://forum.instantdeveloper.com/viewtopic.php?f=5&t=86482&p=158813

I voted yes on the proposal for change mentioned (PRP000481) (English Translation follows):
as discussed in the forum in it would be useful to have a mask for the time and datetime fields that allows you to see the time in AM / PM format
such as "hh: mm" gives 17:35 it could be that "hh: mm AA" gives "05:35 PM" - that is, if the mask has "AA" the hours go up to 12 and AA becomes AM or PM. Any other implementation is obviously fine.


...jack
ljwilson
 
Posts: 559
Joined: 26 November 2013, 14:15

Re: How to set times to show hh:nn am or pm

Postby ljwilson » 16 August 2020, 16:25

I recently had need for this in a report. Attached is the procedure I used. Not as nice as having a mask for it, but it did the job.

2020-08-16_12-22-22.png
2020-08-16_12-22-22.png (38.24 KiB) Viewed 301 times

...jack
ljwilson
 
Posts: 559
Joined: 26 November 2013, 14:15


Return to Tips & Tricks

Who is online

Users browsing this forum: No registered users and 3 guests

cron