Date Entry Helper
When you have applications that are used around the world, its a little
confusing for users to enter dates in the correct format. America uses
mm/dd/yy, UK uses dd/mm/yy and Japan uses yy/mm/dd. Is '03/01/02' 3rd Jan 2002?
Or 2nd Jan 2003? Or 1st Mar 2002?
Help is at hand in the form of a short Computed for display test field.
@ReplaceSubstring(@Text(@Date(0099; 11; 22)); "1":"2":"9":"0"; "m":"d":"y":"y")
Set the date to be the 22nd of November in the Year 99. This conversion is done
in the native format of your machine. When placed alongside a Date field it
offers a small reminder on how to enter your dates. Try that the next time a
Japanese businessman enters a date on a UK designed database on a US server.
Start the conversation
0 comments