UiPath Documentation
studio
2021.10
false
  • Release Notes
    • 2021.10.3
    • 2021.10.4
    • 2021.10.5
    • 2021.10.6
    • 2021.10.7
    • 2021.10.8
    • 2021.10.9
    • 2021.10.10
  • Getting Started
    • Introduction
    • About Backward and Forward Compatibility
    • The User Interface
    • Keyboard Shortcuts
    • Signing in to Your Account
    • Configuring Studio Settings
    • Project Templates
      • Orchestration Process
      • Background Process
      • Robotic Enterprise Framework
      • Transactional Process
      • Trigger Based Attended Automation
    • Creating a Basic Process
    • Creating a Basic Library
    • Tutorials
  • Setup and Configuration
    • Hardware and Software Requirements
    • Install Studio
      • Deployment guidelines
      • Services Studio Connects To
      • Common Installation Errors
      • Modify or Uninstall Studio
    • Activate Studio
      • About Licensing
    • Update Studio
    • Command Line Parameters
    • Supported Applications and Technologies
    • Enabling Gmail for Email Activities
    • Opting Out of Telemetry
  • Automation Projects
    • About Automation Projects
    • About Publishing Automation Projects
    • About Libraries
      • Loading Web Services in Libraries
      • Activities Generated from Web Services
    • Managing activity packages
    • Configuring Activity Project Settings
    • Signing Packages
    • Governance
    • Importing Entities
    • Modern Design Experience
    • Linking a Project to an Idea in Automation Hub
  • Dependencies
    • About Dependencies
    • Managing Dependencies
    • Project Dependencies Mass Update
      • Mass Update Command Line Parameters
    • Missing or Invalid Activities
  • Types of Workflows
    • Sequences
    • Flowcharts
    • State Machines
    • Global Exception Handler
  • File Comparison
    • About File Comparison
    • Comparing Files
  • Automation Best Practices
    • Workflow Design
    • UI Automation
    • Project Organization
    • Automation Lifecycle
  • Source Control Integration
    • About Version Control
    • Managing Projects With GIT
    • Managing Projects With TFS
    • Managing Projects With SVN
    • Workflow Diff
  • Debugging
    • About Debugging
      • Test Activities
      • Debugging Actions
      • The Locals Panel
      • The Call Stack Panel
      • The Breakpoints Panel
      • The Watch Panel
      • The Immediate Panel
      • Remote Debugging
  • The Diagnostic Tool
    • About The Diagnostic Tool
  • Workflow Analyzer
    • About Workflow Analyzer
    • Naming Rules
      • ST-NMG-001 - Variables Naming Convention
      • ST-NMG-002 - Arguments Naming Convention
      • ST-NMG-004 - Display Name Duplication
      • ST-NMG-005 - Variable Overrides Variable
      • ST-NMG-006 - Variable Overrides Argument
      • ST-NMG-008 - Variable Length Exceeded
      • ST-NMG-009 - Prefix Datatable Variables
      • ST-NMG-011 - Prefix Datatable Arguments
      • ST-NMG-012 - Argument Default Values
      • ST-NMG-016 - Argument Length Exceeded
    • Design Best Practices
      • ST-DBP-002 - High Arguments Count
      • ST-DBP-003 - Empty Catch Block
      • ST-DBP-007 - Multiple Flowchart Layers
      • ST-DBP-020 - Undefined Output Properties
      • ST-DBP-023 - Empty Workflow
      • ST-DBP-024 - Persistence Activity Check
      • ST-DBP-025 - Variables Serialization Prerequisite
      • ST-DBP-026 - Delay Activity Usage
      • ST-DBP-027 - Persistence Best Practice
      • ST-DBP-028 - Arguments Serialization Prerequisite
    • Project Anatomy Rules
      • ST-ANA-003 - Project Workflow Count
      • ST-ANA-005 - Check Project.json Exists
      • ST-ANA-006 - Main Workflow Exists
      • ST-ANA-009 - File Activities Stats
    • Maintainability and Readability Rules
      • ST-MRD-002 - Activity Name Defaults
      • ST-MRD-004 - Unreachable Activities
      • ST-MRD-005 - Redundant Sequences
      • ST-MRD-007 - Nested If Clauses
      • ST-MRD-008 - Empty Sequence
      • ST-MRD-009 - Deeply Nested Activities
      • ST-MRD-011 - Write Line Usage
      • ST-MRD-017 - Incomplete If
    • Usage Rules
      • ST-USG-005 - Hardcoded Activity Arguments
      • ST-USG-009 - Unused Variables
      • ST-USG-010 - Unused Dependencies
      • ST-USG-014 - Package Restrictions
      • ST-USG-020 - Minimum Log Messages
      • ST-USG-024 - Unused Saved for Later
      • ST-USG-025 - Saved Value Misuse
      • ST-USG-026 - Activity Restrictions
      • ST-USG-027 - Required Packages
      • ST-USG-028 - Restrict Invoke File Templates
    • Performance and Reusability Rules
      • ST-PRR-004 - Hardcoded Delay Activity
    • Reliability Rules
      • ST-REL-006 - Infinite Loop
    • Security Rules
      • ST-SEC-007 - SecureString Argument Usage
      • ST-SEC-008 - SecureString Variable Usage
      • ST-SEC-009 - SecureString Misusage
  • Variables
    • Managing Variables
    • The Variables Panel
    • Types of Variables
      • Text Variables
        • Example of Using a Text Variable
      • True or False Variables
        • Example of Using a True or False Variable
      • Number Variables
        • Example of Using a Number Variable
      • Array Variables
        • Example of Using an Array Variable
      • Date and Time Variables
        • Example of Using a Date and Time Variable
      • Data Table Variables
        • Example of Using DataTable Variables
    • UiPath Proprietary Variables
  • Arguments
    • Managing Arguments
    • The Arguments Panel
    • Using Arguments
  • Imported Namespaces
    • About Imported Namespaces
    • Managing Namespaces
  • Control Flow
    • About Control Flow
    • Control Flow Activities
      • The Assign Activity
      • The Delay Activity
        • Example of Using the Delay Activity
      • The Do While Activity
        • Example of Using a Do While Activity
      • The If Activity
        • Example of Using an If Activity
      • The Switch Activity
        • Example of Using a Switch Activity
      • The While Activity
        • Example of Using a While Activity
      • The For Each Activity
        • Example of Using a For Each Activity
      • The Break Activity
        • Example of Using a Break Activity
  • Object Repository
    • About Object Repository
    • Creating an Object Repository
    • Reusing Objects and UI Libraries
  • Logging
    • Studio Logs
    • Setup Logs
    • OCR Diagnostic Logs
    • Logging Levels
    • Types of Logs
    • Protecting Sensitive Information
  • The ScreenScrapeJavaSupport Tool
    • About the ScreenScrapeJavaSupport Tool
    • Argument Descriptions for the ScreenScrapeJavaSupport Tool
  • Studio testing
    • Introduction
    • Application Testing
      • Execution Templates
    • Testing project templates
      • SAP Testing Project
    • Test Cases
    • Data-Driven Testing
    • RPA Testing
    • Test Case Templates
    • Test Explorer
      • Test Results
      • Activity Coverage
    • Mock Testing
    • API Test Automation
  • Extensions
    • About extensions
    • SetupExtensions Tool
    • UiPath Remote Runtime
    • Extension for Chrome
      • Group Policies
      • Troubleshooting
    • Extension for Edge
      • Group Policies
      • Troubleshooting
    • Extension for Firefox
      • Troubleshooting
    • Extension for Java
      • Troubleshooting
    • Extension for Silverlight
    • Extension for Citrix
      • Troubleshooting
    • Extension for Microsoft Remote Desktop and Apps
      • Troubleshooting
    • Extension for VMware Horizon
    • SAP Solution Manager Plugin
    • Excel Add-in
  • Troubleshooting
    • About Troubleshooting
    • Microsoft App-V Support and Limitations
    • Internet Explorer X64 Troubleshooting
    • Microsoft Office Issues
    • Identifying UI Elements in PDF With Accessibility Options
    • Identifying UI Elements After Windows Updates
      • Solutions
    • JxBrowser Applications Troubleshooting
    • User Events Monitoring
    • Citrix Troubleshooting
UiPath logo, featuring letters U and I in white
OUT OF SUPPORT

Studio User Guide

Last updated Oct 23, 2025

Example of Using a Date and Time Variable

To exemplify how you can work with a date and time variable, we are going to build an automation that gets the current date and time, subtracts a specific amount of time and writes the result to a Microsoft Excel spreadsheet.

  1. Create a new sequence.
  2. Create two DateTime variables, Today and LastTime.
  3. Create a TimeSpan variable, called Span, and in the Default field type 1.02:10:04.
    Note: The default value attributed to theSpan variable uses the day.hh:mm:ss format.
  4. Add an Assign activity to the Designer panel.
  5. In the Properties panel, in the To field, add the Today variable.
  6. In the Value field, type Now. This gives you the date and time when the project is executed, in the dd/MM/yyyy and hh:mm:ss formats.
  7. Add another Assign activity under the previous one.
  8. In the Properties panel, in the To field, add the LastTime variable.
  9. In the Value field, type Today.Subtract(Span). This is going to subtract the default value of the Span variable from the current date, stored in the Today variable.
  10. Add an Excel Application Scope activity under the last Assign one.
    Note: Use the Manage Packages feature to download the Excel activities, if you do not already have them installed.
  11. In the Properties panel, in the WorkbookPath field, type the path of the Excel file you want to write to, between quotation marks. In our case, "%HOMEPATH%\Desktop\urgent_invoice.xlsx".
    Note: If the file does not exist at the provided path, it is going to be created.
  12. Add a Write Cell activity in the Excel Application Scope activity.
  13. In the Properties panel, in the Range field, type the coordinates of an Excel cell between quotation marks. In our case, "E3".
  14. In the Sheet Name field, type the name of the sheet in which you want to write. In our case, "Invoice". Note that if the sheet does not exist, it is going to be created.
  15. In the Value field, type LastTime.ToString. This transforms the value of the LastTime variable to a string and writes it to the coordinates previously given.

    The final project should look as in the following screenshot:



  16. Press F5. The automation is executed.
  17. Navigate to your Excel file and double-click the cell in which you added the date. Note that the time and date information is displayed in the cell you pointed towards.


Was this page helpful?

Connect

Need help? Support

Want to learn? UiPath Academy

Have questions? UiPath Forum

Stay updated