In a form view I have a formula that takes the right 11 of a time field and the result in my form in โndard Time)โ. The expression assistant says it should be 5:00:00 AM which is right. Is this just because of the form view? Itโs right when its displayed in a table view.
Solved! Go to Solution.
No, actually; there is no long format for Time values (only Ignore seconds, which is a shorter format). I am perplexed! I feel like I recall RIGHT() and LEFT() exhibiting odd behavior when passed non-Text input. Try forcing [OpenHours]
to Text with:
right(([OpenHours] & ""), 11)
or:
right(concatenate([OpenHours]), 11)
Whatever the case, this definitely looks like a bug.
Thatโs weird!
What does RIGHT(Time field, 100)
produce?
Also, why are you using RIGHT() on a Time value?
Is it a Time value? Or a DateTime value?
#notmyformula this is a coworkerโs app that I am assisting on the development while hes busy with something else.
(He doesnโt clean up his forms to not show virtual columns that donโt need to be there )
Obviously, thereโs some inconsistency between the Expression Assistant and the app itself. There are a number of such inconsistencies. You just have to work around them. You could also report this as a bug to support@appsheet.com.
Is the column Time or DateTime?
What is the stored value? Is the stored value text (e.g., a plain text spreadsheet cell, or a CHAR or VARCHAR database column), or a temporal type?
itโs a text column based on the value of a time column, so I assume that the default conversion for a time to text field is a long time format of some sort?
No, actually; there is no long format for Time values (only Ignore seconds, which is a shorter format). I am perplexed! I feel like I recall RIGHT() and LEFT() exhibiting odd behavior when passed non-Text input. Try forcing [OpenHours]
to Text with:
right(([OpenHours] & ""), 11)
or:
right(concatenate([OpenHours]), 11)
Whatever the case, this definitely looks like a bug.
It only appears in the form which is odd. Its a virtual column formula so really shouldnโt need to be shown in there in the first place.
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |