Skip to main content
A
Adam5CAB
Participant
April 1, 2021
Answered

Date Formatting

  • April 1, 2021
  • 2 replies
  • 638 views

Hi,

I have recently upgraded to CF2021.

I am having an issue with date formatting.

I have the code below.

 & #DateFormat(Now(),'YYYY')#& "_" & #DateFormat(Now(),'MM')# & "_" & #DateFormat(Now(),'DD')
the output is    2021_04_91
 
But it should be 2021_04_01
 
It appears to put a 9 instead of a 0
Would anyone might know what would be causing this?
    This topic has been closed for replies.
    Correct answer Charlie Arehart

    Well, to be clear, that is only if you have applied update 1 (from last week). If not, the JVM arg will do no good unless you do also get and implement a special hotfix that was made available to solve this problem (by way of that jvm arg which it enabled and honors). For more, see my blog post from soon after CF2021 was released in November:

     

    https://www.carehart.org/blog/client/index.cfm/2020/11/24/breaking_change_in_cf2021_dateformat_D_vs_d 

    2 replies

    A
    Adam5CABAuthor
    Participant
    April 15, 2021

    Thanks for the help, Problem solved 🙂

      BKBK
      Community Expert
      BKBKCommunity Expert
      Community Expert
      April 1, 2021

      It was a bug. The solution is to add the following flag

      -Dcoldfusion.datemask.useDasdayofmonth=true

      to your JVM settings.

       

      You can do this in one of 2 ways:

      1. via the ColdFusion Administrator. Go to the page Server Settings > Java and JVM. Place the mouse cursor at the end of the contents of the input field JVM Arguments. Press the space bar once, and add the above flag. Press Submit Changes. Restart ColdFusion.
      2. via the file /cfusion/bin/jvm.config. Open the file in a text editor. Locate the setting that starts with java.args=. The values are on the right-hand-side of the = symbol. Follow the list of values to the very end. Place the mouse cursor there. Press the space bar once, and add the above flag. Save the edited file. Restart ColdFusion.

       

       

        Charlie Arehart
        Community Expert
        Charlie ArehartCommunity ExpertCorrect answer
        Community Expert
        April 2, 2021

        Well, to be clear, that is only if you have applied update 1 (from last week). If not, the JVM arg will do no good unless you do also get and implement a special hotfix that was made available to solve this problem (by way of that jvm arg which it enabled and honors). For more, see my blog post from soon after CF2021 was released in November:

         

        https://www.carehart.org/blog/client/index.cfm/2020/11/24/breaking_change_in_cf2021_dateformat_D_vs_d 

        /Charlie (troubleshooter, carehart. org)
          Terms & ConditionsAccessibility statement
          Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices