Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
gINT | Keynetix Wiki My Expression in Template Studio shows the wrong date
    • Sign In
    • -gINT | Keynetix Wiki
      • +gINT
      • +gINT Collector
      • +gINT Civil Tools
      • -Keynetix
        • +Installing or Upgrading to CONNECT Edition
        • +Archive Webinars
        • +HoleBASE
        • +HoleBASE Civil Extension
        • +HoleBASE Data Entry
        • +HoleBASE Excel Extension
        • -HoleBASE Template Studio
          • +HoleBASE Template Studio:Getting Started
          • -Template Studio: FAQs
            • +Designing Depth Related Areas
            • -Expressions
              • Excel Functions
              • How To Display a Full Location Type Rather than an Abbreviation
              • How To edit the Stratum Detail Descriptions to include the depth information
              • How to show top and base levels in the 'level' column.
              • How To use Text Styling to Make part of the Geology Description Bold
              • Is there a common list of requested Expressions available?
              • Log Only Functions
              • Mathematical Functions
              • My Expression in Template Studio shows the wrong date
              • Run Time Functions
              • Text Styling
              • Why do the numbered remarks in my data not appear on new lines on my templates?
            • +Loading and Saving Templates
          • +HoleBASE Template Studio:How Tos
          • +HoleBASE Template Studio:Issues
          • HoleBASE Template Studio Release Notes
        • +KeyAGS
        • +KeyLAB
        • +Keynetix Component Downloads
        • +Working from Home with Keynetix Products
        • Hardware Specifications and Recommendations
        • Supported Platforms

     
     Questions about this article, topic, or product? Click here. 

    My Expression in Template Studio shows the wrong date

      Product(s): Keynetix
      Version(s): 1.0
      Area: Assist

    My Expression in Template Studio shows the wrong date

    Issue Summary

    When producing a template that shows a date format, it can be very easy to plot the date using the minutes instead of the months.

    Resolution

    Please note the following syntax;

    • text(now(),'dd/mm/yyyy')

    This would give the following result;

    • Day/Minute/Year

    The syntax for months actually uses a capital 'M' and therefore the syntax should be as follows;

    • text(now(),'dd/MM/yyyy')

    This would give the following result;

    • Day/Month/Year

    This could be expanded to give you a full date and time of log production such as follows;

    • text(now(),'dd/MM/yyyy hh:mm:ss')

    This would give the following result;

    • Day/Month/Year Hour:Minutes:Seconds.

    • Migrated
    • Share
    • History
    • More
    • Cancel
    • wiki.author Created by Bentley Colleague wiki.author
    • When: Tue, Jun 9 2020 9:37 PM
    • Revisions: 1
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies