1. Home
  2. Knowledge Base
  3. FAQs
  4. Advanced Settings
  5. Cast Date and Time Attribute as DateTime

Cast Date and Time Attribute as DateTime

Certain data extraction tools require a DateTime attribute instead Date or Time data type. If your Entity has a Date or Time attribute, you can convert it to DateTime by following the steps below.

Go to the Builder. In the Projectย โ†’ย Advanced tabย โ†’ย Set โ€˜Cast Date and Time attributes as DateTimeโ€™ = ON

Advanced Settings
Advanced Settings

In the attribute tab, you will notice that the Date and Time attributes have been converted to DateTime type.

List of Attributes
List of Attributes

When you launch the Test link and navigate to the Metadata, you will see that Date and Time attributes have been converted to DateTimeOffset.

Service Metadata
Service Metadata

When you launch the Test link and navigate to the Entity, you will see that the time element has been appended to the Date.

Data is converted to DateTime format
Data is converted to DateTime format.
Was this article helpful?

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support