Date format for worldwide use

[master333]

Hi 

Just wondering if we could have an option for both date formats please?

European format = dd/mm/yyyy

US format = mm/dd/yyyy

Thanks

[Kevin_Flynn]

If that's the case, we might as well allow the user to specify it in a string format, e.g. similar to Excel. The user could specify this in 'Launchbox' and it carries over to 'BigBox'. Sometimes I prefer '-' instead of '/', etc.  As Launchbox is developed in C#, Jason should be able to simply validate the format before proceeding; otherwise, a popup or it highlights it.

Users can then make it so: "Mar 5, 1985", "2013-2-01", etc.

The database itself should have a preferred format in US.

Months as 1–12 : m

Months as 01–12 : mm

Months as Jan–Dec : mmm

Months as January–December : mmmm

Months as the first letter of the month : mmmmm

Days as 1–31 : d

Days as 01–31 : dd

Days as Sun–Sat : ddd

Days as Sunday–Saturday : dddd

Years as 00–99 : yy

Years as 1900–9999 : yyyy

 

Edited February 3, 2017 by Kevin_Flynn