1 Reply Latest reply on Apr 24, 2012 6:38 PM by hardwired-solutions

    Date Format


      I have a date field with the year only having the 1st 2 digits.


      Example: 04/09/20


      How do I add the last 2 digits of the year?





        • 1. Re: Date Format

          Hello Sam,


          If the intended date from your example is 04/09/2020 and the field is a date or timestamp field, you can change the display of the field by entering the layout mode, selecting the field, then going to the Data tab on the inspector and selecting the desired format in the Data Formating section.


          If the intended date is 04/09/2000, you'll need to replace the contents of the field with a calculation, like GetAsText ( <fieldName> ) & "00".