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?
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.
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
Yeah that worked.
Thanks mate!
You’re welcome @SKETCHwade
User | Count |
---|---|
46 | |
29 | |
24 | |
22 | |
13 |