MS Excel - Australian date format for future date check

[MattWW (Matt)]

Hi all,

I currently have a bot whereby I want to check invoice dates to see if there are future dates.

When I read the excel file into a DT it’s converting the date to US format. Also, when I tick the preserveformat checkbox, it brings back exactly what is in the cell, which unfortunately is “#'s” due to the cell not being wide enough.

Any advice would be appreciated.

[Nisa]

Would this help?

Guidance on String/DateTime Conversion and String Manipulation

I agree in that some things are not explained well, like I still don’t get what CultureInfo is for; I just know how to validate the syntax by using the full name “System.Globalization.CultureInfo.InvariantCulture” (if I remember right). If this helps, DataTime is always in the same format… MM/dd/yyyy hh:mm:ss.0 or something like that. So, whenever you convert a date into that format you are going to get it like that no matter what (from my understanding). You can convert a date using the C…

I’d get a similar issue, with the automatic conversion of datetime, and I had to do it in this manner too (but with a DT you might have to change each value in a ForEach loop I think).

[siddharth]

Please provide more information on your post [what is this Australian Date format? Do you want to change the format in the date column itself or do you want to change it when you use it somewhere, say when entering it on some text field expecting a date value in Australian format? ] or just attach the excel file and your workflow.