AnsweredAssumed Answered

Salesforce date comparsion

Question asked by robin.zhang344808 on Oct 22, 2018
Latest reply on Oct 23, 2018 by britto.parthalomew

Hi, everyone


I try to persist 'LastModifidate' as a comparison value for my integration process. General process follows that 1) pulling records from salesforce connector with 'Lastmodifiedate' is greater than the most recent 'LastModifiedDate' run in the previous process. 2) Persis the most recent 'LastModifiedDate' in the current process.


The problem is that SF date follows such format 2018-10-22T19:10:00.000Z. But once this value is pulling from salesforce and stored in dynamic process property, the date format automatically converted to boomi internal format 20181022 191000.000. And an error message will be thrown if I compare two date in different format. 


I am wondering is there a way I can keep SF format as a dynamic process property. Thanks!!!! (I tried to paly around it in map shape with string and date format, but both failed)