Search results

Thanks for the clarification. I redesigned the table and have now a date field, I also have the StartTime and EndTime set to time format, I have also abandoned the idea of considering 25:15 format as 01:30 in the morning and have using the normal short time criteria As i have only a start date...

I need to track the length of a duty, some duties go beyond the midnight therefore are recorded as 24:15 for a 00:15 and 25:35 for a 01:35 the next morning as the date is referred to the start of the duty. The StartTime and EndTime fields are currently set as numbers with input mask ‘00:00;0;_’...

Thanks for helping out with the code and spotting the error in the table!!

I am trying to use the Lookup function to retrieve the description form the table tCodes and apply the description value in the description box in the form tDes with the After Update For example if the users types any number between 100 and 199 in the Code field, the Description is...

I think I answered my question...:eek: if(greater(item()?['Days'], 0),1, 0)

I need the correct formula to count the items from a Get items, I need to count those records where Days is greater than 0. I have a variable TotCount with the he expression: if(greater(item()?['Days'], 0), 0, 1) The above code always returns 0, below are a few example of what I need: Days...