Strange Time Calculation

AppSheet AppSheet Q&A
1

I know this one is a bit out there, but I’m getting some strange results when using this expression:

TIME(Asset Log[Timestamp]) -
ANY(SELECT(Asset Log[Out],
AND([Associate Name]=[_THISROW].[Associate Name],DATE(Asset Log[Timestamp])=DATE([_THISROW].[Timestamp]),[Action]=TRUE)
))

What it should be doing is selecting a timestamp, then comparing it to the previous, and calculating the difference. What it’s doing is spitting out a date from 1969.

It may be because it’s almost midnight and I’m falling asleep at my desk, that I can’t see why, but I thought I’d offer it up for anyone who’s more awake than I. Any suggestions welcome.

Notes: [Action] is just a Boolean to show on duty/off duty.

2

There may be other issues, but in your expression’s TIME function in the first line you likely need to either remove the table reference, leaving just the column reference, or else wrap the table+column reference in parent functions in order to return a single value–like INDEX(SELECT(Asset Log[Timestamp], row-select-criteria), 1).

1 Like