{{tag>Function Function_List Date_And_Time}} ====== TIME_ADD ====== ===== Description ===== Returns the timestamp resulting from adding/subtracting the specified number of hours to the specified timestamp ===== Syntax ===== ''TIME_ADD (timestamp, hours)'' ===== Parameters ===== An expression producing timestamp and an expression producing a number to be added or subtracted (if the number is negative) to the timestamp ===== Returns ===== **Timestamp**: the timestamp with the given number of hours added (subtracted if negative). ===== Example ===== IF TIME_ADD (Account.OpeningTime, 4) = 07/04/2004 12:00 THEN ... ===== Related ===== [[ref:a_f:f:af:date_add|DATE_ADD]], [[ref:a_f:f:af:month_add|MONTH_ADD]], [[ref:a_f:f:af:timestamp|TIMESTAMP]], [[ref:a_f:f:af:current_timestamp|CURRENT_TIMESTAMP]]