I was wondering if anyone knows how to do the following using DBASE expressions.
I need the ability to take two fields that has been formated for time (either using military time or regular AM/PM time) and perform calculations on them such as the following:
Time1: 13:30 (or 1:30p)
Time2: 16:30 (or 4:30p)
Time2 - Time1 = 3 (hours and minutes could vary)
using either FMTTIME() or TIME() or any other comparible DBASE time expression for this.
I use goldmine as a reservation system and need to perform mathmatival calculations based upon time for billing purposes.
Am am familiar with LOOKUP.INI so any help using expressions directly in Goldmine or by using lookup.ini would be very helpful!
Thank you in advance
I need the ability to take two fields that has been formated for time (either using military time or regular AM/PM time) and perform calculations on them such as the following:
Time1: 13:30 (or 1:30p)
Time2: 16:30 (or 4:30p)
Time2 - Time1 = 3 (hours and minutes could vary)
using either FMTTIME() or TIME() or any other comparible DBASE time expression for this.
I use goldmine as a reservation system and need to perform mathmatival calculations based upon time for billing purposes.
Am am familiar with LOOKUP.INI so any help using expressions directly in Goldmine or by using lookup.ini would be very helpful!
Thank you in advance