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

Gokul001 (Gokul Balaji) October 5, 2022, 2:46pm 2

Hi @DimitriLYR

How about this expression

DateTime.ParseExact(YourString,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Regards
Gokul

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