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 |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |