Friday, September 21, 2018

Create a Custom Field that Pulls Up the Current Date and Time

To create the field, perform the following steps:

     1. Navigate to Customization > Lists, Records, & FieldsTransaction Body Fields or (Transaction Line Fields) > New.
     
     2. Provide a Label.
     
     3. Set Type to Free-Form Text.
     
     4. Uncheck Store Value.
     
      5. In the Applies To tab, check where to apply the field (e.g. Sales).
     
     6. In the Validation & Defaulting tab, set the following:

         Default Value: to_char(current_date,'mm/dd/yyyy hh:mi:ss')

         Formula = T

     7. Click Save.

No comments:

Post a Comment