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 over 7 years ago

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 over 7 years ago

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

------------------------------
Cancel
Vote Up 0 Vote Down

Cancel

Reply

Former Member over 7 years ago

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

------------------------------
Cancel
Vote Up 0 Vote Down

Cancel

Children

No Data