ContributionsMost RecentMost LikesSolutionsComparing time value with current time value using Now() function I want to compare the time value currently we have in our data with the current time value and I'm using Now() function for this but due to seconds difference it is not able to compare. For example: if we have the date time value as 12/21/23 3:30PM and I want to check if current time is equal to 12/21/23 3:30PM (Now()= 12/21/23 3:30PM) then return true else false but due to seconds value it is giving incorrect result/false. Any suggestions to solve this? Regards, Hunny ------------------------------ Hunny Vinod Kumar ------------------------------ Re: How to add two fields and put the sum in one of the fieldsEdit: I tried using 2 fields ------------------------------ Hunny Vinod Kumar ------------------------------ How to add two fields and put the sum in one of the fields Hi, I have one field and I want to do the cumulative sum in that field. For example suppose I have one field T1 and user has entered value 10 initially so that field should show value 10. Next time when user enter another value let say 20, then it should show sum of current value in T1 field (10) plus the latest value(20) which is 30. Is there any way to achieve this? I tried using three fields 1st T1 which get the actual value 2nd T2 which will store the previous value of T1 and if first time user is entering the value in T1 then T2 should show the value of T1 next time when user enter the value in T1 then it should show sum of T2 value + new T1 value and put that value in T1. Please help if it is feasible to do in quickbase ------------------------------ Hunny Vinod Kumar ------------------------------