|
| |
|
|
box
Posts: 167
Joined: 12/10/2002
Status: offline
 |
Display blanc - 9/14/2009 3:14:10
<%If FP_FieldVal(fp_rs,"nextapt") <= fixTheDate(Date()) Then%>
<font color="#FF0000"><%Response.write "Old Appointment"%></Font>
<%end if%>
Nextapt is data/time field and fixTheDate(Date()) returns the curent date like date() I want if nextapt is older than fixTheDate(Date()) then display old appointment but it disply nothing! do you have any idea why? Thanks
|
|
|
|
box
Posts: 167
Joined: 12/10/2002
Status: offline
|
RE: Display blanc - 9/14/2009 11:40:32
Thanks for reply, now it disply for date newer than today also including older date no appointment! I useded this:
<%If FP_FieldVal(fp_rs,"nextapt") <= fixTheDate(Date()) Then%>
<font color="#FF0000>Old Appointment</font>
<%else%>
<font color="#FF0000>No Data Found</font>
<%end if%>
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
