Date operation

Automate tricky issues around date and time data in your businesses processes. ThinkAutomation will perform various operations on dates and run any number of conditional automations as part of your workflows. To set up, simply drag and drop your conditions and actions via our automation studio.

Date operation – overview

• The baked-in date operation feature can perform the following actions:

• Get date – extract the date from any text or variable and return it to another variable in a predefined format
• Get time – extract just the time from any text or variable and return it to another variable in a predefined format
• Get date and time – extract the date and time from any text or variable and return it to another variable in a predefined format
• Get interval – calculates an interval between a ‘’From’ and ‘To’ date and returns the value to a variable
• Add to – adds an interval value to an existing date/time extracted from any text or variable and returns the new date time to a variable in a predefined format
• Subtract from – subtracts an interval value to an existing date/time extracted from any text or variable and returns the new date time to a variable in a predefined format

Date operation – use cases

• Convert from one date and time column type to another
• Calculate date and time differences
• Verify if a date is a working day for user
• Calculate age
• Use flow variables for date and time configurations
• Convert a date from user time zone to server time zone
• Plus countless more, depending on your desired use case