How would i get the parameter field in a Dreamweaver recordset to default to the latest date in a recordset?
I have a table (UT_DATE) that has a ton of week ending dates. I have the below parameter that has a default of 08/12/2012. How do I tell the parameter to check the UT_DATE table for the last weekending (I'm assuming a date diff) and make that my default.
So my table field has dates 08/12/2012, 08/19/2012, 08/26/2012, 09/02/2012, 09/09/2012...If they viewed it now I would want it to default to 09/02/2012 (the current week)...
Recordset1__dt = "08/12/2012"
If (Request.Form("WeekEndingx") <> "") Then
Recordset1__dt = Request.Form("WeekEndingx")