Knowledge Base

Using a Date Calculation

How can we help?

Browse Common Categories

Getting Started with

Using a Date Calculation

  1. Under the Integration tab, click on the Additional Columns tab.
  2. Click on the Add Additional Column Button.
Add Additional Column Button
  1. The Additional Column window opens.
Additional Column Window
  1. Name – Enter a name for the column.
  2. Type – Select Date Calculation.
  3. Additional fields are displayed in the window.
Date Calculation Window

  1. If a date format already exists enter data in the following fields:
  • Source Column – Select the data source field that contains the required date.
  • Source Format – Select source date format.
  • Target Format – Select the output date format.
  1. If a date format needs to be created. Click on the Manage Formats tab.
Manage Formats Window
  • Name – Enter a name for the format.
  • Format – Enter the date format.
  • Culture – Select the Culture from the dropdown list.
  1. Save the format.
  2. After the date format is created, the user will need to add the format to the Integration process by following Step 7 above.

Email an Expert

Start a Ticket

Chat with Us


Submit a Ticket


Call Us

  • Microsoft Dynamics 365
Get Started

SmartConnect is designed with specialty & deep experience in the core technologies we focus on.

iPAAS & on-premise integration tools that let you connect your cloud and on-premise applications.

© 2023 SmartConnect|eOneSolutions
Cloud Terms of ServicePrivacy PolicyTerms of ServiceEULA

How can we help?