K3 Documents

Add/Subtract Time to a Date

Updated on

Copy and Paste the following formula using your data where necessary.

Description:  

Add 12 hours to a Date

new java.util.Date({Value Date}.getTime()+(3600000L * 12))
Click to copy
Previous Article Nested IF Statement
Next Article Compare Dates