Hi there. I have a small problem. I read a CSV file and keep it in a DataTable: [readCSV] Then I paste this Data Table using Excel activity [writeCSV] The problem is that my DataTable is giving me the RIGHT output format: [good] And in my Excel file, the format is not good… [bad] How can I …

Hello @DimitriLYR Try this DateTime.ParseExact(YourString,"MM/dd/yyyy HH:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy") or DateTime.ParseExact(YourString,"MM/dd/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Date format in DataTable

Help Activities

Aleem_Khan (Aleem Anwer) October 5, 2022, 10:36pm 6

Where you need to put this expression as he said he is directly copy from datatable to excel ?

Topic		Replies	Views
Datatable date format has different format compared to source (.xlsx) Help datatable , activities , question	3	1575	January 13, 2020
Date parsing Activities datatable , activities , studio , question , system	4	877	April 13, 2023
Date Format changing after reading CSV Help studio	24	7485	October 29, 2019
How to change the date format in Data Table Studio activities , question	3	1920	February 24, 2022
Convert a string to Date format Activities excel , activities , question	10	9403	January 8, 2022

Date format in DataTable

Related topics