Convert multiple date formats into a standard way

[ppr (Peter Preuss)]

@manjesh_kumar
Before forcing of doing with LINQ lets divide and conquer on the different building blocks.

Part: Week Info recognition
Week portion is not part of the date format patterns, so we have to handle different. also we do have different cases to approach: week, week range, date.

For recognizing it we can make use of Regex and Group names:

we do init a regex object with the pattern
we do iterate and execute the regex.match
in a switch we do calculate which of the group was firing and will use the group name for the fork

Other Steps
within the cases we can do the additional parsing, date calculation and target datatable population.

Getting date from WeekNo, have a look here for a similar sample as starter help:

Convert Week into Date

@jahidKM lets do following: lets split the 03.2021 into year and week [grafik] init the first Year day, calculate the offset to the first friday of the year [grafik] retrieve the week offset (same week or next week) [grafik] So we can do the final calculation [grafik] Find starter help here GetFriday_FromWeekNo.xaml (7.1 KB) in .Net 5 a function for this was added, but unfortunately we cannot use it, as we do run via different infrastructre (.Net Framework)

For the part from above find starter help here:
manjesh_kumar.xaml (9.6 KB)