How to convert date, if cell is empty

[supermanPunch (Arpan)]

Hi @AaronMark ,

I would suggest you to go through the below Post :

[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…

In accordance with that, we would require to know whether there are different formats of date present in the data.

Once we identify the format/formats of date values we can use the solutions provided in the post to convert to DateTime.

Try to Debug the workflow and Check the value of Data_Completamento_Ordine when it errors out in the Debug Panel.

We should be able to understand the cause better in that way.