1

I am pulling in a date field from a secondary (Japan) SFDC org into our native org. The format in the Japan org shows it as just a date (yyyy-MM-dd) but when I look at the date in the data connection link it comes in as yyyy-MM-dd'T'HH:mm:ss.SSS'Z' with all the timestamp showing as 0s. I try to force the simple date format in the connection but the results still show the timestamp. I am trying to make the conversion in the dataflow but it returns the following error message:

Something went wrong while executing the ConvertPOtoCloseDate node: expression data type, UNKNOWN, is not supported for field 'CloseDateJ' (02K80000000PROFEA4_03C0U000000LqZeUAK)

when I try converting with SAQL code DATEVALUE('POdate__c') I get the following error message:

Something went wrong while executing the ConvertPOtoCloseDate node: invalid field expression DATEVALUE('POdate__c') for field 'CloseDate': Function doesn't have a type check definition: DATEVALUE (02K80000000PROFEA4_03C0U000000Lqb1UAC)

I need to add to this description the fact that our Japan Org POdate maps to the native org's Closedate so I am renaming the output to Closedate and appending the Japan "CloseDate" to our native "CloseDate".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.