Skip to main content

 

 

Coupa Success Portal

Difference between contract end dates in the UI and database

Database is in UTC, while the UI uses the time zone set on the Company Information page.

Database adds difference between UI and UTC because you want the contract to be ending at midnight… not in the middle of the day

So the UI end date is stored in date time = midnight

Database then converts date time to UI midnight (+/- UTC time difference)

 

This will come into play when a customer uploads contracts via API.  The API timestamp must be intended for database time (i.e. contract end date +/- hours difference from UTC)

Picture1.png