Date formates for different geographies

[Leeladhar_Ladia]

I have one database which has many types of date formats based on the geography. So while doing any automation how can we manage these formats and maintain the accuracy?

[ppr (Peter Preuss)]

harmonize it within a default format. Multiple gormats handling in one go have a look here:

How do I parse in multiple datetime format strings into DateTime?

@gerlynn_lxy have a look here: Parsing_MultipleFormats_DTConfig.xaml (13.0 KB) the fourth argument within the ParseExact working with date formats is missing go eg for a DateTime.ParseExact(row(0).ToString.trim, arrFormats, cultureinfo, DateTimeStyles.None) where arrFormats = your DateFormats, cultureinfo is a prepared variable for shortening the code just import the namespace as below: [grafik]

[Leeladhar_Ladia]

Thanks, it is working fine.
Leeladhar Ladia

[ppr (Peter Preuss)]

Perfect.

May we ask you to close the topic once it passed your final testings? Thanks

Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum