Anyone else have this issue? Column with typ...

(SKETCHwade) #1

Anyone else have this issue?

Column with type time and ignored seconds Initial value = 06:00:AM

If I do not edit it from its initial value I get the error: Value ‘06:00:AM’ in field ‘Start Time’ cannot be converted to type ‘Time’

But if I input the time manually to the form it allows it. It’s as though I have used special characters in initial value.

Any ideas?

(Levent KULAÇOĞLU) #2

@SKETCHwade

You should remove the colon in front of AM

= 06:00 AM

You can even use it as 06:00 and AppSheet will treat it AM automatically. To refer 06:00 PM, you can use 18:00.

(SKETCHwade) #3

I’m positive I tried that but it didn’t allow it, I’ll look again though.

Yeah I will try it without AM/PM and see how it goes

(SKETCHwade) #4

Yeah that worked.

Thanks mate!

(Levent KULAÇOĞLU) #5

You’re welcome @SKETCHwade