Skip to main content
Adam5CAB
Participant
Apr 1, 2021 7:51 AM UTC
Answered

Date Formatting

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 is closed to new replies. Start a new post to keep the conversation going.
    Charlie Arehart
    Charlie ArehartCorrect answer
    Community Expert
    Apr 2, 2021 3:47 AM UTC

    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)
    View reply

    3 replies

    Adam5CABAuthor
    Participant
    Apr 15, 2021 5:42 AM UTC

    Thanks for the help, Problem solved 🙂

    Translate
      BKBK
      Community Expert
      BKBKCommunity Expert
      Community Expert
      Apr 1, 2021 9:08 AM UTC

      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.

       

       

      Translate
        Charlie Arehart
        Community Expert
        Charlie ArehartCommunity ExpertCorrect answer
        Community Expert
        Apr 2, 2021 3:47 AM UTC

        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 

        Translate
        /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