LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: khopkins

Hello,
I am using version 4.6.1 to export data into salesforce and i require the datatype of date to be a different format than CCYY-MM-DD can this be accomplished and if so how as other posts i have found say that this is not possible?

If this is not possible is there a work aroound as the export datatype of date needs to have the format of DD/MM/CCYY

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

There are a number of ways to achieve this:
one is....

stringField = format("%02d/%02d/%04d",day(dateField),month(dateField),year(dateFie ld))
emit stringField

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: khopkins

Hi Stony will this export the data as an actual date data type in a viewer or csv export?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

No, it'd be a string data type instead, but CSV only supports strings, so it should work.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: khopkins

Hi Stoney yes apologies for the confusion with csv but i need the fields to export into the salesforce nodes as a date datatype but with the format of DD/MM/CCYY not CCYY-MM-DD.

I have been told Salesforce requires data imports for dates in a date datatype but in the specific format for UK of DD/MM/CCYY or MM/DD/CCYY for US date format