- About JET
- Administration
- Creating an App
- Basic Functions
- Advanced Functions
- Automation Parameters
- Field Value Selection
- Field Value Formatting
- Field Value Manipulation
- Total Count of a Form
- Total Sum of Field
- Minimum Value of Field
- Maximum Value of Field
- Average Value of Field
- Site Level Parameters - Site Name
- Site Level Parameters - Login User
- Site Level Parameters - Login User Email
- Owner Email
- Check Permission Group
- Date Time Addition
- Email Image
- CheckBox Condition
- Usage of Time Fields
- Parent Form Updates
- 3rd Party API
- Other Features
- Known Issues & Solutions
- Linux
- Windows
- FAQ (JET)
6.14.Date Time Addition
Date Time Addition
Step 1: Go to Manage Forms > Automation > Add Automation > Select Action Type and choose ‘Set current event values’
Step 2: We can use the below value.
field1=calcTime('+7 day')
You can replace ‘+7 day’ with other values.
‘+13 minute’
‘+11 month’
‘+11 hour’
‘+7 year’
This will calculate the time based off current time.
OR if you want to calculate based off existing date values.
datefield2=calcTime('-2day','{datefield1}')
This will allow you to do calculations based of an existing record value.