I am attempting to calculate a time difference between two DateTime objects. The first object is system.date.now(). The second object is giving me trouble. the second object is taken from a row in a dataset that was populated with a SQL query to a MySQL database.
current_datetime = system.date.now() event_set_time = tbl.getValueAt(selrow, 'IG_Event_Set_time')
The customer wants to know the time difference in minutes (since_reset_time).
Something along the order of:
The event_set_time DateTime can actually be up to 10 days prior to current_datetime. The customer wants the since_reset_time in minutes. Every attempt I have made to calculate this number has resulted in some sort of datatype error.