I have this formula in a Time type column as the initial value:
IF(
CONTEXT("View")="My Time Entries_Form",
"00:00:00",
""
)
This is the explanation underneath
IF this condition is true:
....(CONTEXT(
........"View")) is equal to ("My Time Entries_Form")
THEN use the value of:
...."12/30/1899 12:00:00 AM"
ELSE use the value of:
....""
Surely it should be โ12:00:00 AMโ and not โ12/30/1899 12:00:00 AMโ for a time type column?
I agree, it shouldnโt show like that.
This is similar to time in a Date type column - it actually does have a time component of โ00:00:000โ or โ12:00:000 amโ. Thatโs why you can actually interchange/compare Date and DateTime columns.
I am not sure how AppSheet is managing it, but I do know from other languages they have a single construct used for Date, Time or DateTime data types. They simply โturn onโ which part of the component is being used in the column type.
I suspect AppSheet is doing something similar, which means for a Time type, the Date component is defaulted to the MIN Date which looks like right now that is โ12/30/1899โ. This will not be a problem for Time columns as they ALL will have this MIN Date specified.
I do wonder what the behavior is if you tried to compare a Time with a DateTime or Date?
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |