Adding dates but omitting Sunday 1

[rosn459]

The search function is down and I'd like to resolve this today.

If I have a date (today for example) and I want to show the date six days in the future; but, I want to omit Sunday as a day.

How would I do this? I've gotten this far:

<cfset FutureDate = #dateformat(Today(), 'mm/dd/yyyy')#+6>
<cfoutput>#FutureDate#</cfoutput>

The result of the above is 12/2/2004 and I need it to be 12/3/2004.

Thanks so much!!!

 

[ecobb]

You're close, you need to use the DayOfWeek function to find out what day of the week your "FutureDate" is on.

Try this:

<cfset FutureDate = #dateformat(Today(), 'mm/dd/yyyy')#+6>
<cfif DayOfWeek(FutureDate) EQ 1>
  <cfset FutureDate = FutureDate+1>
</cfif>
<cfoutput>#FutureDate#</cfoutput>

Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher

 

[rosn459]

Ecobb,

Thanks bunches!!!!!

 

[TruthInSatire]

gotcha covered.

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)