Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Exchange with SD4.5 - How to pass Deadline Offset - Stacy

Highlighted
StacyWhetzell
Collector

Data Exchange with SD4.5 - How to pass Deadline Offset - Stacy

I'm using Data Exchange to read values from Excel to create Changes. I can set Deadline as an Offset value (an integer # of days to add to CurrDate, to derive Deadline).

However, I need to be able to pass Offset from the Excel Sheet, rather than via Template.

Does anyone know how to do this?
Thanks much
Stacy Whetzell
1 REPLY
Err_1
Honored Contributor

Re: Data Exchange with SD4.5 - How to pass Deadline Offset - Stacy

Hi,

I believe that you can add the Deadline column to the excel file, and send the offset value (integer #) in this column; then when creating the Change record from Data Exchange, it should take this value and add it to current time.

Regards;
Randall Barrantes
SW Support Delivery Manager
//Add this to "OnDomLoad" event