Date Type error, Date with year 1999 is not working but working on date with year 2000

[supermanPunch (Arpan)]

Hi @Anelisa_Bolosha1 ,

Could also check with the below post on recognising the formats of the date (as sometimes the date format from Excel and Datatable differs) and using the appropriate date format after the analysis is done :

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", Culture…