Date conversion in Skyvia

  • 18Views
  • Last Post 06 July 2020
  • Topic Is Solved
0
votes
Ibha Gupta posted this 02 July 2020

Hi,

I amd receiving date as string value e.g. '13/04/2017' from ftp csv and want to store it in date/time field in Salesfroce. i am not able to conver it via Skyvia. Could you please guide me for this conversion from String to date/time in Skyvia?

 

Regards,

Ibha Gupta

Order By: Standard | Newest | Votes
1
votes
Mariia Zaharova posted this 03 July 2020

 Hello Ibha,

 

Please try using an Expression mapping. For example:

(DT_DBDATE)[your_string_column]

 

Please tell us if this helps.

 

Best regards,

Mariia

  • Supported by
  • Ibha Gupta
0
votes
Ibha Gupta posted this 06 July 2020

Thanks for the response and it worked great. I want to know about the if condition also in expressions. This is common feature which should be applied for any data manupulation in Skyvia. Either If or If-else.

 

Regards,

Ibha Gupta

1
votes
Mariia Zaharova posted this 06 July 2020

Hello Ibha,

 

 

Regarding the format for if..else expressions please refer to https://docs.microsoft.com/en-us/sql/integration-services/expressions/conditional-ssis-expression?view=sql-server-ver15

 

Best regards,

Mariia

  • Supported by
  • Ibha Gupta
Close