K3 Documents

Add/Subtract Time to a Date

Updated Nov 22, 2019

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))
Previous Article Nested IF Statement
Next Article Compare Dates