Options
  • Locked Locked
  • Replies 12 replies
  • Subscribers 11 subscribers
  • Views 2197 views
  • Users 0 members are here
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Date Format Change

jdillon
Is there a way to change the date format from the default of MM/DD/YYYY to DD/MMM/YYYY, example being today's date of 18NOV2016?

Cheers.
Parents
  • Former Member
    Former Member
    Use Calculated value with vbscript sth like this:

    -----------------------------
    Option Explicit

    ' Get Document date.

    Dim szDatums
    szDatums = PropertyValues.SearchForProperty( 1185 ).TypedValue.DisplayValue

    Dim szMonth
    szMonth = MONTH(szDatums)
    Dim szYear
    szYear = YEAR(szDatums)

    ' Create title.

    Dim szName
    szName = "MyReport - " & szYear & "." & szMonth

    ' Set result.

    Output = szName

    ------------------------------
Reply
  • Former Member
    Former Member
    Use Calculated value with vbscript sth like this:

    -----------------------------
    Option Explicit

    ' Get Document date.

    Dim szDatums
    szDatums = PropertyValues.SearchForProperty( 1185 ).TypedValue.DisplayValue

    Dim szMonth
    szMonth = MONTH(szDatums)
    Dim szYear
    szYear = YEAR(szDatums)

    ' Create title.

    Dim szName
    szName = "MyReport - " & szYear & "." & szMonth

    ' Set result.

    Output = szName

    ------------------------------
Children
No Data
M-Files
M-Files Support


© 2025 M-Files, All Rights Reserved.