Knowledge Base

Using a Date Calculation

How can we help?

Browse Common Categories

Getting Started with SmartConnect.com

Using a Date Calculation

  • Under the Integration tab click on the Additional Columns tab.
  • Click on the Add Additional Column button.

  • The Additional Column window opens.

  • Name – enter a name for the column.
  • Type – select Date Calculation.
  • Additional fields are displayed in the window.

  • 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.
  • If a date format needs to be created click on the Manage Formats tab.

    • Name – enter a name for the format.
    • Format – enter the date format.
    • Culture – select the Culture from the dropdown list.
  • Save the format.
  • After the date format is created, the user will need to add the format to the Integration Process by following Step 7 above.
Support

Email an Expert

Start a Ticket
Support

Chat with Us

Support

Submit a Ticket

Support

Call Us

Product
Connections
  • Microsoft Dynamics 365
Templates
Engage
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.

© 2021 SmartConnect|eOneSolutions
Privacy PolicyTerms of ServiceEULA

How can we help?

clear