DD/MM/YYYY Date Format

Walaikum Assalam my dear brother @omaralmaary

I understand your point but from the code point of view, it is difficult to understand for a computer what is the following date means
’12/12/2021′;
A computer will take the first part as a Month and the second part as a day.
It will never understand the UK format with ‘/’ unless you tell it that it is a UK format, which means somewhere we need another input to tell the computer to use the 1st part as a date. It cannot be automatic.

Hope it answers the issue.
If you have any suggestions please feel free to share them with me.

I am always open to correcting and improving this system inshaaAllah.

Mustafiz.

Assalaamu alaykum,
I understand that something needs to tell your software to distinguish between MM/dD and dd/mm.

I was hoping you could have an option dying upload to set it to British date format/option or manually selecting your format?

If it’s too much effort to have that, we can stick to the notepad option of switching date format manually which is just search and replace ??

Jazakallah khair br Omar,
You got it perfectly.
Yes, so during the upload the system need to be told the CSV is a British date format.

But since it is not something that needs to be done every day, I thought it was OK for brother to do a search/replace ??

Mustafiz.