Convert DateTime to Date field in Salesforce

  • 81Views
  • Last Post 01 July 2022
Ali Mahmood posted this 24 June 2022


I have a few columns in my CSV import file that contain DateTime values in the format of DD/MM/YY HH:MM and I would like to convert them to a target date field in Salesforce with the format that is accepted by Salesforce (like YYYY-MM-DD). I do not need the time values, just the date.

How do I do this in Skyvia using the Expression formulas? Can I leave the source definition to DT_DBDATE or is DT_AUTO correct?

Nataliia Nikulina posted this 01 July 2022

Hello Ali,

Thank you for contacting Skyvia Support team. 

What goal do you try to achieve in converting dates? In general, if you need to simply import a CSV file to a Salesforce using an Import package, it is not necessary to use any expressions to convert data as under the hood Skyvia works with universal time. 

The most important thing is that the CSV file should be able to upload to the package. 

Should you have any further questions, let us know. 

Best regards,