Missing zero on time extract

[john6]

Hi,

I’m saving some data in the database as type ‘date’, this is required for various reasons. It stores the information as expected.

Later on I want to display the time only so I am extracting the hours and minutes as text, however any time that has two zero’s such as in this example only shows one. I’m guessing it’s a bug but is there a way around this at all?

[petter]

Are you extracting hours and minutes separately? This is probably not necessary. Instead, use formatted as:

[john6]

Thanks for the reply. Yes, I’m extracting as text as I only want the time, I don’t want the date. As I’m doing it this way the only formatting options I get would be as follows;

[petter]

The reason that it’s showing a single zero is that for a computer, 00 is treated simply as 0.

If this is only for displaying a certain time (and not the date), I’d go with the following:

[simon]

John

Petter is spot on, you don’t need to do the extract if it is already stored as a date - just format the date to just show the time.

Simon

[john6]

Thanks Petter, Simon. That’s made my life a lot easier and works as you said it would.

Thanks again

John

[petter]

Awesome!