Skip to main content
Ruszaj
Participant
June 29, 2006
Answered

Max Date

I am trying to output the max date of a subset of a query using cfloop query (determined by the number of records to be displayed). I can determine the max date for the results of the entire query, but not the subset. Any ideas would be greatly appreciated.
    This topic is closed to new replies. Start a new post to keep the conversation going.
    web-spinnersCorrect answer
    Inspiring
    June 29, 2006
    Create a variable and initially set it to the first date in the loop. Then check it for every iteration.
    View reply

    4 replies

    RuszajAuthor
    Participant
    June 29, 2006
    THANK YOU WEB-SPINNERS!
    Translate
    Dan_Bracuk
    Inspiring
    June 29, 2006
    How are you generating the subset?
    Translate
    RuszajAuthor
    Participant
    June 29, 2006
    <cfloop query="searchResults" startrow="#form.startRow#" endrow="#form.endRow#">
    </cfloop>
    Translate
    web-spinnersCorrect answer
    Inspiring
    June 29, 2006
    Create a variable and initially set it to the first date in the loop. Then check it for every iteration.
    Translate
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices