Filter data table problem

[ppr (Peter Preuss)]

@Olivera_Kalinic

but when I print it to output, I’m getting these values

Ship Date format

We would recommend to handle / harmonize the date value before adding the QueueItem / populating the Specific Content In the case for handling this numerical value you can do: [grafik] So for robusten it up you can think about cascading the datevalues cell formating value format type check handling dateTime Strings handling OADate numbers

Parse date into a single format

we can make use of the following building blocks: [grafik] Parsing many formats in one go ensure the following: [import_systemglobalization] arrFormats = {“dd/MMM/yyyy”, “dd-MM-yyyy”, … your other formats} DateTime.ParseExact(YourString, arrFormats, cultureinfo.InvariantCulture, DateTimeStyles.None) feel free to adapt the culture info Finally we can check which case we do have to handle e.g. with regex \d+ → OADate NA → not parseable … Bringing all together we can parse the date and…