Manage Learn to apply best practices and optimize your operations.

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.

Dig Deeper on Domino Resources - Part 3

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...