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
- Backup emails
- Email attachment storage
- Email parsing
- Email sentiment analysis
- Email to cloud
- Email to CRM
- Email to CSV
- Email to database
- Email to spreadsheet
- Email translation
- Move email attachment to folder automatically
- Outlook export all emails
- Parse email attachment
- Translate attachment
Database
- Data ETL
- Database automation
- Database counters
- Database monitoring
- Mongo update
- SQL to Excel
- Translate database
- Update a database
Telephony
CRM
- CRM data entry
- CRM sentiment analysis
- Dynamics automation
- Salesforce automation
- SugarCRM automation
- Zoho automation
Automation actions
- Automatic compression
- Automatic encryption
- Automatic translation
- Create hash file
- Database lookup
- Date operation
- Detect language
- Execute PowerShell
- Execute script
- Extract field
- File operation
- FTP download
- FTP upload
- GeoIP lookup
- MongoDB lookup
- OAuth sign-in
- Process files
- Run a program
- Send Teams message
- Sentiment score
- Set variable
- Speak text
- SQL command to update data in a database
- SQL execute command
- String operation
- Summarise text
- Train sentiment analysis model
Product
- .NET scripting
- Automation gateway
- Automation IDE
- Automation studio
- C# scripting
- Continuous processing
- Design actions
- High speed automation
- HTTP API
- JSON parser
- Local automation
- Markdown support
- Message store
- Public web API
- RPA community
- RPA designer
- SendGrid mail server
- Text summariser
- Visual Studio code paste without formatting