AnsweredAssumed Answered

Is it better to use time or timestamp

Question asked by tap4pat on Nov 14, 2018
Latest reply on Nov 14, 2018 by CarlSchwarz

I want to show just the time in my fields. They are enroutetime, arrivaltime, endtime. I want to be able to calculate the difference in time. Everything was fine until my end time was past midnight, since then you have to account for the change in day. My users just want to enter the time, not have to enter time and date, that is why I started with setting the fields as time. So I then thought just have them enter the time, the account for the date in a calculation.

 

My second question is, is there a way to have a time picker like you can have a calendar pop up for picking the date.

Outcomes