Skip to main content
A
Anonymous
January 31, 2019
Question

New to CF and seeking help with DateTimeFormat

  • January 31, 2019
  • 1 reply
  • 515 views

Hi there,

I'm new to CF and trying to format a timestamp but no matter what I try I am unable to get the DateTimeFormat function to work successfully so I am hoping that some one with more experience might be able to quickly identify what I am doing incorrectly.

Goal: trim the timestamp

<cfscript>

     unformattedTime = "{ts '2018-11-05 12:13:50'}";

     formattedTime =  DateTimeFormat(unformattedTime, "yyyy-mm-dd HH:nn:ss");

       writeOutput(formattedTime);

</cfscript>

Expected Output: 2018-11-05 12:13:50

Actual output: nothing

This topic has been closed for replies.

1 reply

EddieLotter
EddieLotter
Inspiring
January 31, 2019

If you paste your example code into cfFiddle you will see it works as expected, however, you should probably use the CreateDateTime() function to initialize the unformattedTime variable.

A
Anonymous
January 31, 2019

Thank you for your reply. It is very much appreciated. I just realised that the reason its not working is that Im using an older version of CF that doesn't support the DateTimeFormat so I had to use the separate DateFormats and timeFormats to resolve it. Thanks again.

BKBK
BKBK
Community Expert
February 2, 2019

Please mark the correct answer. It will help someone else in future.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices