ColdFusion DateTimeFormat() Utility Function

Posted May 22, 2007 at 7:31 AM

Tags: ColdFusion

I love ColdFusion's DateFormat() and TimeFormat() functions; they are hugely useful. And, most of the time, I use them independently of each other. But, often enough, I use DateFormat() followed by TimeFormat(). Wouldn't it be cool if ColdFusion had a DateTimeFormat() function that would accept both a date and a time mask? I think it would be, and here's what it might look like:

 Launch code in new window » Download code as text file »

  • <cffunction
  • name="DateTimeFormat"
  • access="public"
  • returntype="string"
  • output="false"
  • hint="Formats the given date with both a date and time format mask.">
  •  
  • <!--- Define arguments. --->
  • <cfargument
  • name="Date"
  • type="date"
  • required="true"
  • hint="The date/time stamp that we are formatting."
  • />
  •  
  • <cfargument
  • name="DateMask"
  • type="string"
  • required="false"
  • default="dd-mmm-yyyy"
  • hint="The mask used for the DateFormat() method call."
  • />
  •  
  • <cfargument
  • name="TimeMask"
  • type="string"
  • required="false"
  • default="h:mm TT"
  • hint="The mask used for the TimeFormat() method call."
  • />
  •  
  • <cfargument
  • name="Delimiter"
  • type="string"
  • required="false"
  • default=" at "
  • hint="This is the string that goes between the two formatted parts (date and time)."
  • />
  •  
  •  
  • <!---
  • Return the date/time format by concatenating the date
  • and time formatting separated by the given delimiter.
  • --->
  • <cfreturn (
  • DateFormat(
  • ARGUMENTS.Date,
  • ARGUMENTS.DateMask
  • ) &
  •  
  • ARGUMENTS.Delimiter &
  •  
  • TimeFormat(
  • ARGUMENTS.Date,
  • ARGUMENTS.TimeMask
  • )
  • ) />
  • </cffunction>

Using the above ColdFusion user defined function, you could easily format date/time values:

 Launch code in new window » Download code as text file »

  • <!---
  • DateTimeFormat called with all possible
  • defaulted arguments.
  • --->
  • #DateTimeFormat(
  • Now()
  • )#
  •  
  •  
  • <!---
  • DateTimeFormat called with explicit date
  • and time masks and default delimiter.
  • --->
  • #DateTimeFormat(
  • Now(),
  • "mmm d, yyyy",
  • "h:mm TT"
  • )#
  •  
  •  
  • <!---
  • DateTimeFormat called with explicit date and
  • time masks as well as an explicit delimiter.
  • --->
  • #DateTimeFormat(
  • Now(),
  • "mmm d, yyyy",
  • "h:mm TT",
  • " at the time of "
  • )#

The above code would give us the following output:

22-May-2007 at 7:24 AM
May 22, 2007 at 7:24 AM
May 22, 2007 at the time of 7:24 AM

I'm sure this has been done before, but I just really hope that one day Adobe adds it to the ColdFusion built-in function list.

Download Code Snippet ZIP File

Post Comment  |  Ask Ben  |  Other Searches  |  Print Page




Reader Comments

May 22, 2007 at 7:47 AM // reply »
11 Comments

Yup, Ray did it back in 2001 and has it on his cflib.org site http://www.cflib.org/udf.cfm?ID=134

cflib.org hasn't got much press lately and it's easy to forget the wealth of udf's on the site.


May 22, 2007 at 8:01 AM // reply »
7,572 Comments

@Chris,

It's funny, right after I posted this, I did a quick Google search to see if this was out there already (as I assumed it was) and there it was, CFLib as the second search result.

2001... I guess that means I'm only 6 years behind the Jedi :) The force is weak with me.


May 22, 2007 at 9:34 AM // reply »
235 Comments

Heh, people _do_ forget about CFLib, so it is no big deal. ;) I need to get off my ass and release that new version that I've been talking about since 2004. ;)


May 22, 2007 at 9:45 AM // reply »
95 Comments

Ben, good job anyway. If nothing else you made me aware of the existing function at cflib. Thanks!


May 22, 2007 at 9:47 AM // reply »
7,572 Comments

@Ray,

Some of the best meals I have ever eaten were cooking over many many hours... that doesn't exactly translate to web sites, other than to say, good things are worth the wait.


May 22, 2007 at 11:58 AM // reply »
56 Comments

@Ray,

Are you ever going to just integrate cflib into riaforge?


May 22, 2007 at 12:11 PM // reply »
235 Comments

No plans. I really look at RIAForge as more for 'projects', not single CFCs/UDFs/tags. Now that is NOT official RIAForge policy. Shoot, even I have a single CFC up there I believe. But in GENERAL those are my thoughts. (Have to treat carefully here. I admin both sites, but Adobe is the official owner of RIAForge. Etc etc etc.)


Del
Jul 19, 2009 at 5:39 PM // reply »
1 Comments

Thanks a lot Ben this was really helpful.

Changed the Defaults to mm/dd/yyyy HH:mm:ss

It worked like a charm.


Jul 19, 2009 at 5:40 PM // reply »
7,572 Comments

@Del,

Glad you are finding this useful.


Post Comment  |  Ask Ben

Recent Blog Comments
Mar 21, 2010 at 3:59 PM
Exploring ColdFusion Component Runtime Class Properties And Serialization
@Elliott, according to Ben's experiment, serializeJSON() doesn't access the private data by default - it doesn't even access the getHair() method - so trying to clone a Girl.cfc via serializeJSON/des ... read »
Mar 21, 2010 at 3:49 PM
Ask Ben: Javascript String Replace Method
I'm confused a bit by what you are asking, but if had this sentence: The color, red, is in the style statement; style: red;. and wanted to remove all or change all of the commas, colons, and semi-c ... read »
Mar 21, 2010 at 3:13 PM
Ask Ben: Javascript String Replace Method
I am trying to make a java program to count the number of times that these punctuation marks occur in a body of text: , : ; . ! - ' " ? / \ I am using this piece to ferret out the commas: numcommas ... read »
Mar 21, 2010 at 11:13 AM
A New Wrist Pain
@chiropractor suwanee, Spoken like someone trying to sell something. Other than for minor, temporary relief from some back pain, chiropractic treatment is nothing but placebo effect and quackery. ... read »
Mar 21, 2010 at 6:32 AM
ColdFusion CFPOP - My First Look
Apologies... The field name in the db for C. is "BounceCode" It stores the code / message which is returned in the email. Sorry for the confusion. ... read »
Mar 21, 2010 at 6:29 AM
ColdFusion CFPOP - My First Look
@Jose Galdamez, Hi Ben and Jose 1st of all.. big thanks to Jose for his Skype chat a few weeks back. Your time was much appreciated. I have come up with a rather unelegant solution to my problem a ... read »
Mar 21, 2010 at 3:42 AM
A New Wrist Pain
Chiropractic treatment is one of the best methods for treating numerous health problems naturally. After years of experience being a chiropractor, I have found that it is a powerful way to solve many ... read »
Mar 20, 2010 at 12:07 PM
Drawing On The iPhone Canvas With jQuery And ColdFusion
Simply awesome. Saved my day. ... read »