Hi Sandy, I have finally realized what my code/program was doing. After
back-tracking a bit here is what I found:
<cfset TD=Now()>
<cfquery name="r" datasource="DB">
Select * From Employees Where DateDiff('yyyy', #DateFormat(TD, "mm/dd/yyyy")#,
Dob) < 49
</cfquery>
<cfloop query="r">
<cfoutput>#DateFormat(r.Dob, "mm/dd/yyyy")#<br /></cfoutput>
</cfloop>
This gave me the follwing results:
01/13/1919
11/09/1936
05/26/1937
03/09/1938
12/28/1942
01/31/1943
12/27/1947
It's returning the years before 1949. Some simple adjustments should
straightent this mess out. Again, thank you very much for you help and time.
One day hopefully I can contribute and help out others who have problems.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2387
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
