Hello,

please help me, i want to display a date using coldfusion report builder. The date that i want to display has a condition which is:
-display a date 3 days from today except saturday and sunday.

I'm using below statement to display the date, but the output always in condition 1. It's anything wrong in my statement?

<cfif (IsDate(ToString(DateFormat(Now(),"dddd/ddmmyy"))) EQ (IsDate(ToString("Monday/ddmmyy"))) OR (IsDate(ToString(DateFormat (Now(),"dddd/ddmmyy"))) EQ (IsDate(ToString("Tuesday/ddmmyy")))) OR (IsDate(ToString(DateFormat (Now(),"dddd/ddmmyy"))) EQ (IsDate(ToString("Sunday/ddmmyy")))))>

DateFormat (3 + Now (), "dddd/dd")

<cfelseif (IsDate(ToString(DateFormat (Now(),"dddd/ddmmyy"))) EQ (IsDate(ToString("Wednesday/ddmmyy"))) OR (IsDate(ToString(DateFormat (Now(),"dddd/ddmmyy"))) EQ (IsDate(ToString("Thursday/ddmmyy")))) OR (IsDate(ToString(DateFormat (Now(),"dddd/ddmmyy"))) EQ (IsDate(ToString("Friday/ddmmyy")))))>

DateFormat (5 + Now (), "dddd/dd")

<cfelse>
DateFormat (4 + Now (), "dddd/dd")
</cfif>


Please help me....

This post has been edited by eera: 14 Jan, 2008 - 09:02 PM

Hello,

I've already solve the problem. The coding is:

<cfif (DayOfWeekAsString(DayOfWeek(Now())) EQ DayOfWeekAsString(2) OR (DayOfWeekAsString(DayOfWeek(Now())) EQ DayOfWeekAsString(3)) OR (DayOfWeekAsString(DayOfWeek(Now())) EQ DayOfWeekAsString(1)))>
DateFormat (3 + Now (), "ddmmyy")
<cfelseif (DayOfWeekAsString(DayOfWeek(Now())) EQ DayOfWeekAsString(7))>
DateFormat (4 + Now (), "ddmmyy")
<cfelse>
DateFormat (5 + Now (), "ddmmyy")
</cfif>

-That is 1 (Sunday) - 7 (Saturday).