Ask Ben: Getting the Previous Day In ColdFusion, Excluding Saturday And Sunday
Posted July 22, 2007 at 1:32 PM
The question is too long to list here, but basically someone contacted me looking for help with a file review system. The part that was causing issue was the fact that he needed to review the files from the previous day. In order figure out the previous day Tuesday-Friday, it was fine. When it comes to weekend, changing of the month, or changing of the year, he was doing a whole lot of crazy date alterations.
No problem - we've all been there. Until you realize how much Date/Time functionality ColdFusion has built-in, you usually do take it upon yourself to figure out all the logic required to handle things like weekends and year cross-overs. Thankfully, ColdFusion plays very nicely with date math, and when date math is not enough, ColdFusion's DateAdd() function can really pick up the slack. In addition to that, ColdFusion also has Year(), Month(), and Day() functions for parsing out parts of the date/time stamp.
Long story-short, getting the previous day (excluding weekends) is as easy as calling ColdFusion's DateAdd() function with the "w" date part. The "w" date part stands for Weekday. For a long time, I didn't understand the difference between Day and Weekday in the context of DateAdd(). They do basically the same thing, most of the time. The difference, which can be subtle depending on what date you are looking at, is that adding or subtracting Weekdays to and from a date will hop over the weekends. Therefore, if you add a weekday to Friday, it will return the next Monday. Similarly, if you subtract a Weekday from a Monday, it will return the previous Friday.
This being said, getting the previous weekday is quite a simple task. To demonstrate, we will get the previous 10 weekdays (excluding Saturday and Sunday):
Launch code in new window » Download code as text file »
- <!---
- Get the current DATE. Fix()'ing the date will chop
- off the time portion of the date/time stamp.
- Caution: This will result in a NUMERIC date, not
- a standard date.
- --->
- <cfset dtNow = Fix( Now() ) />
-
- <!---
- Now, let's loop over the past 10 WEEKDAYS. This is
- different from days. Weekday math does not include
- weekends in its calculations.
- --->
- <cfloop
- index="intOffset"
- from="0"
- to="10"
- step="1">
-
- <!--- Get the WEEKDAY that we want to show. --->
- <cfset dtDay = DateAdd( "w", -intOffset, dtNow ) />
-
- <!---
- Output the full date so we can see BOTH the day
- of the week and the day-date.
- --->
- #DateFormat( dtDay, "full" )#<br />
-
- </cfloop>
Running the above code, we get the following output:
Monday, July 23, 2007
Friday, July 20, 2007
Thursday, July 19, 2007
Wednesday, July 18, 2007
Tuesday, July 17, 2007
Monday, July 16, 2007
Friday, July 13, 2007
Thursday, July 12, 2007
Wednesday, July 11, 2007
Tuesday, July 10, 2007
Monday, July 9, 2007
Notice that neither Saturday nor Sunday are showing up in this list. ColdFusion makes life easy.
Download Code Snippet ZIP File
Comments (9) | Post Comment | Ask Ben | Permalink | Other Searches | Print Page
Fixing DIVs That Cause Content Truncation When Printing
Heroes' Hayden Panettiere - Odd Tan Line Or ColdFusion Enthusiast? (Saucy)
Reader Comments
Hi Ben.
I originally saw this question here: http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=3&threadid=1285943&enterthread=y
Note my - purposely abrupt - response to it. Thankfully the OP realised it was for emphasis rather than anything else.
So this is my moment for "I've learned something today". I had no idea that dateAdd() had a "weekday" option.
It would be great if you could post something on the Adobe forums pointing to your post here (or just replicate the answer), lest anyone accidentally stumble across the issue and decide either Frank's or my suggested solution is the best way forward.
Cheers.
--
Adam
Posted by Adam Cameron on Jul 23, 2007 at 8:34 AM
@Adam,
I have posted a link on the Adobe Forums. It's funny, I never use the Adobe forums, and this is like the second or third time that I have been asked the same exact question as one on the forums. At least, this time it was the same person who contacted me (Frank) as the person who posted on the forums.
For the longest time I knew that WeekDay was there as an option, but I could not for the life of me figure out what HECK was the difference between a Day and Weekday???? I mean what other kind of day is there? A MonthDay??? It wasn't until I was working with an event calendar that I realized what the Weekday actually did.
Posted by Ben Nadel on Jul 23, 2007 at 8:41 AM
If you wanted to start helping out on the Adobe forums - even occasionally - that would be cool: we need all the help we can get!
--
Adam
Posted by Adam Cameron on Jul 23, 2007 at 10:20 AM
Hi Ben,
Not as simple as your solution. However, I use the similar function in SQL. I dig it up after I read your blog.
Good post Ben!
Pinal Dave
Posted by Pinal Dave on Jul 23, 2007 at 4:02 PM
Nice SQL UDF. I don't use enough SQL UDFs. They are really handy and can make the queries seem so much nicer.
Posted by Ben Nadel on Jul 23, 2007 at 4:59 PM
With Coldfusion 8 is the weekday option "w" now stand for weeks?
Posted by Chris on Mar 13, 2008 at 7:09 PM
@Chris,
According to the documentation, "w" still stands for weekday.
Posted by Ben Nadel on Mar 17, 2008 at 7:34 AM
I was using your example to deal with a scheduling app I'm writing, and notice that your output returns 11 dates - the date you started with plus the next 10.
Changing the "from" in the loop to "1" skips the date you start with and provides the next 10. Is there something I can change in the looping to give me 10 including the start date - i.e. the date I start with plus 9?
Thanks!
Posted by Susan on Jun 24, 2008 at 3:47 PM
@Susan,
Just go from 0 to 9, rather than 0 to 10.
Posted by Ben Nadel on Jun 25, 2008 at 7:38 AM
