TIME() Values printing differently

[JpChapron]

Hi all,

Might seem weird but since Mid September, all my TIME() values are now printing like this :

12 h 12

Instead of this :

12:12

It's not the end of the world but I know I haven't made any modifications to my app since then and wondering what could be causing this ?

Inside the app itself, the data is still logged in normally and the Google sheet it's stored in shows if with the ":".

My Language is French (Canada) so could that have an impact?

thanks

[WillowMobileSys]

I am not seeing this issue.  Could you show us how you have this column configured and what values are being stored into the column?

If all looks in order, then, at the very least, I would suggest reporting it to AppSheet support.

[JpChapron]

Sure,

Config wise there is nothing I can see that would trigger this, The collumn data Type is TIME and the ignore seconds is checked.

As for how the data is stored, here's a screenshot of my Gsheet :

As you can see it's stored well, the format of the cell is time too.

Anything else I could show you ?

[MultiTech]

If you require a work around, the TEXT() formula is very handy when working with date and time data.

• Time(Text([DateTime], "HH:MM"))
  14:14 - as a time type
• Number(Text([DateTime], "HH"))
  14 - as a number type

[JpChapron]

That's a great idea ! Thanks for the heads up !