Easyflow docs
  • 🚩Introduction
  • Automation
    • 🚀Get Started
    • 🤖Workflows
    • ⚡Run & Invoke
      • Manual
      • Triggers
      • Scheduler
      • WebHook (Instant)
      • Rest API endpoint
      • Transactional vs Queue
      • Online \ Offline
    • 🎶Workflow orchestration
      • Step operations
      • Step configuration
      • Data mapping
    • 👣Steps and conditions
      • Multi steps
      • Parallel steps
      • Conditions
      • Loop & iteration
    • 🎲Dynamic content
      • Variables
      • Function expressions
    • 📦Schema
      • Schema builder
      • Auto schema detection
      • Use cases
    • 🐞Debugging
  • Visualisation
    • 🚀Get Started
    • 🧮Visual designer
      • Dashboard designer
      • Card designer
    • 🔌Datasources
      • Partner connectors
      • Existing connections
      • URL (CSV or JSON)
      • Data pipeline (Flow)
      • Data-blocs
      • Push to visualiser
    • 🎻Data pivoting
    • 📈Chart types
    • 🎨Customisation
      • Card appearance
      • Theme & branding
    • 🤝Preview & sharing
      • URL share
      • Scheduled snapshots
      • Send to TV
      • Preview mode
    • ⌛Refresh settings
  • Data Pipeline
    • 🚀Get Started
    • 🗞️Pipeline (ETL)
    • ⚡Automated runs
    • 🌻Transformation
      • Average by group
      • Change text casing
      • Clean data
      • Combine columns
      • Combine tables
      • Compare dates
      • Convert array of objects to array of arrays
      • Count by group
      • Extract text from column
      • Fill in blanks
      • Filter rows
      • Find and replace
      • Find maximum by group
      • Find min/max per row
      • Find minimum by group
      • Flatten rows
      • Format dates
      • Format numbers
      • Insert date & time column
      • Insert growth rate column
      • Insert if/else column
      • Insert if/else blank column
      • Insert math column
      • Insert row numbers
      • Insert rows
      • Insert running total column
      • Insert text column
      • Limit rows
      • Merge duplicate rows
      • Pivot columns
      • Remove duplicate rows
      • Rename columns
      • Select columns
      • Reorder columns
      • Sort rows
      • Split column
      • Stack tables
      • Sum by Group
      • Unpivot columns
      • Use regex
    • 🕶️Preview results
    • 🎻Orchestration
    • 📤Output
      • For Google Datastudio
      • For Easyflow visualisation
      • Array of arrays
      • Array of objects
  • Connectors
    • 🚀Get Started
    • 🌟Built-in Connectors
      • CSV
      • Data bloc
      • Data mapper
      • Delay (Wait)
      • HTTP
      • For Loop (Iteration)
      • Functions
        • Array functions
        • Conditions
        • Convertors
        • General functions
        • Date & Time
        • Filters
        • Math functions
        • Object functions
        • Operators
        • Text functions
      • Receive emails | IMAP
      • RSS
      • Send emails | SMTP
      • SQL Syntax
      • Trasform
      • Variables Setter
      • WebHook
      • Workflow (Sub flow)
    • 🌠Partner connectors
  • System
    • 👫Teams
    • 🙂Profile
    • 🧑‍💻Monitoring
    • 🔋Account Usage
    • 💵Billing and Pricing
Powered by GitBook
On this page
  • Input/output
  • Settings

Was this helpful?

  1. Data Pipeline
  2. Transformation

Insert date & time column

PreviousFormat numbersNextInsert growth rate column

Last updated 2 years ago

Was this helpful?

The Insert date & time column step adds a column with the current date and time, with customizable offset by days and timezones. The current date and time will be determined at the time the flow is run. This step can be useful for tasks like logging updated times.

Input/output

Connect any data into this step. It'll give you the output data of a new "Current DateTime" column appended to your dataset where the current date and time is noted (based on when the flow is run).

Settings

Pick the dataset. By default, The "New column name" field have "Current DateTime" as a column name, but you can customize this name to anything you prefer.

A date that is 0 days offset will be the current date and time. If you choose a positive value, it will be in the future, while a negative value will be in the past. If we add 1 to the Days Offset field, it shows us the date time stamp for this time tomorrow. If we add -1 to the Days Offset field, it'll show us the date time stamp for this time yesterday.

🌻