Date Fields
 
Non-Indexed /w Time & Allow No Date
to be replaced:         <FORM>
                        <FIELDID>

<table cellpadding="2" cellspacing="0" border="0">
<tr><!--#set var="FORMAT" value="<X-FC-FIELD LANG.7505.1 LITERALSTRING>"--><!--#if expr="!<X-FC-FIELD <FIELDID> DEFAULT=0 NUMBER>"--><!--#set var="YEAR" value="0"--><!--#set var="MONTH" value="0"--><!--#set var="DAY" value="0"--><!--#set var="HOUR" value="0"--><!--#set var="HOUR24" value="0"--><!--#set var="MINUTE" value="-1"--><!--#set var="AMPM" value="0"--><!--#else--><!--#set var="YEAR" value="<X-FC-FIELD <FIELDID> DATE,"%Y">"--><!--#set var="MONTH" value="<X-FC-FIELD <FIELDID> DATE,"%#m">"--><!--#set var="DAY" value="<X-FC-FIELD <FIELDID> DATE,"%#d">"--><!--#set var="HOUR" value="<X-FC-FIELD <FIELDID> DATE,"%#I">"--><!--#set var="HOUR24" value="<X-FC-FIELD <FIELDID> DATE,"%#H">"--><!--#set var="MINUTE" value="<X-FC-FIELD <FIELDID> DATE,"%#M">"--><!--#set var="AMPM" expr="1 + <X-FC-FIELD <FIELDID> DATE,"%P">"--><!--#endif--><!--#while expr="$FORMAT"--><!--#set var="CURFORMAT" expr="@split($FORMAT, ';')"--><!--#if expr="$CURFORMAT == 'Y'"-->
        <td><select name="FieldID:<FIELDID>=DATEYEAR" onchange="RSD(<FIELDID>,-1,1,this.selectedIndex);">
                <option value="0"<!--#if expr="!$YEAR"--> selected="selected"<!--#endif-->><!--#echo expr="@list(`<X-FC-FIELD <FORM>.<FIELDID>.10 LITERALSTRING>`, 0)"--></option><!--#set var="CURRYEAR" value="<X-FC-SERVER-TIME FORM "%Y">"--><!--#if expr="!$YEAR"--><!--#set var="DATE" expr="$CURRYEAR - 6"--><!--#set var="ENDYEAR" expr="$CURRYEAR + 6"--><!--#elif expr="$YEAR < $CURRYEAR"--><!--#set var="DATE" expr="$YEAR - 6"--><!--#set var="ENDYEAR" expr="$CURRYEAR + 6"--><!--#else--><!--#set var="DATE" expr="$CURRYEAR - 6"--><!--#set var="ENDYEAR" expr="$YEAR + 6"--><!--#endif--><!--#while expr="++$DATE < $ENDYEAR"-->
                <option value="<!--#echo var="$DATE"-->"<!--#if expr="$YEAR == $DATE"--> selected="selected"<!--#endif-->><!--#echo var="$DATE"--></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'm'"-->
        <td><select name="FieldID:<FIELDID>=DATEMONTH" onchange="RSD(<FIELDID>,-1,1,this.selectedIndex);">
                <option value="0"<!--#if expr="!$MONTH"--> selected="selected"<!--#endif-->></option><!--#set var="DATE" value="0"--><!--#while expr="++$DATE < 13"-->
                <option value="<!--#echo expr="$DATE"-->"<!--#if expr="$DATE == $MONTH"--> selected="selected"<!--#endif-->><X-FC-FIELD `LANG.603.$DATE` STRING></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'D'"-->
        <td><select name="FieldID:<FIELDID>=DATEDAY" onchange="RSD(<FIELDID>,-1,1,this.selectedIndex);">
                <option value="0"<!--#if expr="!$DAY"--> selected="selected"<!--#endif-->></option><!--#set var="DATE" value="0"--><!--#while expr="++$DATE < 32"-->
                <option value="<!--#echo var="$DATE"-->"<!--#if expr="$DATE == $DAY"--> selected="selected"<!--#endif-->><!--#echo var="$DATE"--></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'H'"-->
        <td><select name="FieldID:<FIELDID>=DATE24HOUR" onchange="RSD(<FIELDID>,-1,1,this.selectedIndex);">
                <option value="-1"<!--#if expr="!$HOUR24"--> selected="selected"<!--#endif-->></option><!--#set var="DATE" value="-1"--><!--#while expr="++$DATE < 24"-->
                <option value="<!--#echo var="$DATE"-->"<!--#if expr="$HOUR24 == $DATE"--> selected="selected"<!--#endif-->><!--#if expr="$DATE<10"-->0<!--#endif--><!--#echo var="$DATE"--></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'I'"-->
        <td><select name="FieldID:<FIELDID>=DATEHOUR" onchange="RSD(<FIELDID>,-1,1,this.selectedIndex);">
                <option value="0"<!--#if expr="!$HOUR"--> selected="selected"<!--#endif-->></option><!--#set var="DATE" value="0"--><!--#while expr="++$DATE < 13"-->
                <option value="<!--#echo var="$DATE"-->"<!--#if expr="$HOUR == $DATE"--> selected="selected"<!--#endif-->><!--#echo var="$DATE"--></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'M'"-->
        <td><select name="FieldID:<FIELDID>=DATEMIN" onchange="RSD(<FIELDID>,-1,1,this.selectedIndex);">
                <option value="-1"<!--#if expr="!$YEAR"--> selected="selected"<!--#endif-->></option><!--#set var="DATE" value="-1"--><!--#while expr="++$DATE < 60"-->
                <option value="<!--#echo var="$DATE"-->"<!--#if expr="$YEAR && ($MINUTE == $DATE)"--> selected="selected"<!--#endif-->><!--#if expr="$DATE<10"-->0<!--#endif--><!--#echo var="$DATE"--></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'p'"-->
        <td><select name="FieldID:<FIELDID>=DATEAMPM" onchange="RSD(<FIELDID>,-1,1,this.selectedIndex);">
                <option value="0"<!--#if expr="!$AMPM"--> selected="selected"<!--#endif-->></option>
                <option value="0"<!--#if expr="$AMPM==1"--> selected="selected"<!--#endif-->><X-FC-FIELD LANG.7526.1 STRING></option>
                <option value="1"<!--#if expr="$AMPM==2"--> selected="selected"<!--#endif-->><X-FC-FIELD LANG.7526.2 STRING></option>
        </select></td><!--#endif--><!--#endwhile-->
        <input type="hidden" name="FieldID:<FIELDID>=DATEEND" value="1"/></td>
</tr>
</table>

Non-Indexed /w Time, Date required
to be replaced:         <FIELDID>

<table cellpadding="2" cellspacing="0" border="0">
<tr><!--#set var="FORMAT" value="<X-FC-FIELD LANG.7505.1 LITERALSTRING>"--><!--#set var="YEAR" value="<X-FC-FIELD <FIELDID> DATE,"%Y">"--><!--#set var="MONTH" value="<X-FC-FIELD <FIELDID> DATE,"%#m">"--><!--#set var="DAY" value="<X-FC-FIELD <FIELDID> DATE,"%#d">"--><!--#set var="HOUR" value="<X-FC-FIELD <FIELDID> DATE,"%#I">"--><!--#set var="HOUR24" value="<X-FC-FIELD <FIELDID> DATE,"%#H">"--><!--#set var="MINUTE" value="<X-FC-FIELD <FIELDID> DATE,"%#M">"--><!--#set var="AMPM" expr="1 + <X-FC-FIELD <FIELDID> DATE,"%P">"--><!--#while expr="$FORMAT"--><!--#set var="CURFORMAT" expr="@split($FORMAT, ';')"--><!--#if expr="$CURFORMAT == 'Y'"-->
        <td><select name="FieldID:<FIELDID>=DATEYEAR"><!--#set var="CURRYEAR" value="<X-FC-SERVER-TIME FORM "%Y">"--><!--#if expr="!$YEAR"--><!--#set var="DATE" expr="$CURRYEAR - 6"--><!--#set var="ENDYEAR" expr="$CURRYEAR + 6"--><!--#elif expr="$YEAR < $CURRYEAR"--><!--#set var="DATE" expr="$YEAR - 6"--><!--#set var="ENDYEAR" expr="$CURRYEAR + 6"--><!--#else--><!--#set var="DATE" expr="$CURRYEAR - 6"--><!--#set var="ENDYEAR" expr="$YEAR + 6"--><!--#endif--><!--#while expr="++$DATE < $ENDYEAR"-->
                <option value="<!--#echo var="$DATE"-->"<!--#if expr="$YEAR == $DATE"--> selected="selected"<!--#endif-->><!--#echo var="$DATE"--></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'm'"-->
        <td><select name="FieldID:<FIELDID>=DATEMONTH"><!--#set var="DATE" value="0"--><!--#while expr="++$DATE < 13"-->
                <option value="<!--#echo expr="$DATE"-->"<!--#if expr="$DATE == $MONTH"--> selected="selected"<!--#endif-->><X-FC-FIELD `LANG.603.$DATE` STRING></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'D'"-->
        <td><select name="FieldID:<FIELDID>=DATEDAY"><!--#set var="DATE" value="0"--><!--#while expr="++$DATE < 32"-->
                <option value="<!--#echo var="$DATE"-->"<!--#if expr="$DATE == $DAY"--> selected="selected"<!--#endif-->><!--#echo var="$DATE"--></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'H'"-->
        <td><select name="FieldID:<FIELDID>=DATE24HOUR"><!--#set var="DATE" value="-1"--><!--#while expr="++$DATE < 24"-->
                <option value="<!--#echo var="$DATE"-->"<!--#if expr="$HOUR24 == $DATE"--> selected="selected"<!--#endif-->><!--#if expr="$DATE<10"-->0<!--#endif--><!--#echo var="$DATE"--></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'I'"-->
        <td><select name="FieldID:<FIELDID>=DATEHOUR"><!--#set var="DATE" value="0"--><!--#while expr="++$DATE < 13"-->
                <option value="<!--#echo var="$DATE"-->"<!--#if expr="$HOUR == $DATE"--> selected="selected"<!--#endif-->><!--#echo var="$DATE"--></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'M'"-->
        <td><select name="FieldID:<FIELDID>=DATEMIN"><!--#set var="DATE" value="-1"--><!--#while expr="++$DATE < 60"-->
                <option value="<!--#echo var="$DATE"-->"<!--#if expr="$MINUTE == $DATE"--> selected="selected"<!--#endif-->><!--#if expr="$DATE<10"-->0<!--#endif--><!--#echo var="$DATE"--></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'p'"-->
        <td><select name="FieldID:<FIELDID>=DATEAMPM">
                <option value="0"<!--#if expr="$AMPM==1"--> selected="selected"<!--#endif-->><X-FC-FIELD LANG.7526.1 STRING></option>
                <option value="1"<!--#if expr="$AMPM==2"--> selected="selected"<!--#endif-->><X-FC-FIELD LANG.7526.2 STRING></option>
        </select></td><!--#endif--><!--#endwhile-->
        <input type="hidden" name="FieldID:<FIELDID>=DATEEND" value="1"/></td>
</tr>
</table>


Non-Index w/o Time, No Date
to be replaced:         <FORM>
                        <FIELDID>


<table cellpadding="2" cellspacing="0" border="0">
<tr><!--#set var="FORMAT" value="<X-FC-FIELD LANG.7505.1 LITERALSTRING>"--><!--#if expr="!<X-FC-FIELD <FIELDID> DEFAULT=0 NUMBER>"--><!--#set var="YEAR" value="0"--><!--#set var="MONTH" value="0"--><!--#set var="DAY" value="0"--><!--#else--><!--#set var="YEAR" value="<X-FC-FIELD <FIELDID> DATE,"%Y">"--><!--#set var="MONTH" value="<X-FC-FIELD <FIELDID> DATE,"%#m">"--><!--#set var="DAY" value="<X-FC-FIELD <FIELDID> DATE,"%#d">"--><!--#endif--><!--#while expr="$FORMAT"--><!--#set var="CURFORMAT" expr="@split($FORMAT, ';')"--><!--#if expr="$CURFORMAT == 'Y'"-->
        <td><select name="FieldID:<FIELDID>=DATEYEAR" onchange="RSD(<FIELDID>,-1,0,this.selectedIndex);">
                <option value="0"<!--#if expr="!$YEAR"--> selected="selected"<!--#endif-->><!--#echo expr="@list(`<X-FC-FIELD <FORM>.<FIELDID>.10 LITERALSTRING>`, 0)"--></option><!--#set var="CURRYEAR" value="<X-FC-SERVER-TIME FORM "%Y">"--><!--#if expr="!$YEAR"--><!--#set var="DATE" expr="$CURRYEAR - 6"--><!--#set var="ENDYEAR" expr="$CURRYEAR + 6"--><!--#elif expr="$YEAR < $CURRYEAR"--><!--#set var="DATE" expr="$YEAR - 6"--><!--#set var="ENDYEAR" expr="$CURRYEAR + 6"--><!--#else--><!--#set var="DATE" expr="$CURRYEAR - 6"--><!--#set var="ENDYEAR" expr="$YEAR + 6"--><!--#endif--><!--#while expr="++$DATE < $ENDYEAR"-->
                <option value="<!--#echo var="$DATE"-->"<!--#if expr="$YEAR == $DATE"--> selected="selected"<!--#endif-->><!--#echo var="$DATE"--></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'm'"-->
        <td><select name="FieldID:<FIELDID>=DATEMONTH" onchange="RSD(<FIELDID>,-1,0,this.selectedIndex);">
                <option value="0"<!--#if expr="!$MONTH"--> selected="selected"<!--#endif-->></option><!--#set var="DATE" value="0"--><!--#while expr="++$DATE < 13"-->
                <option value="<!--#echo expr="$DATE"-->"<!--#if expr="$DATE == $MONTH"--> selected="selected"<!--#endif-->><X-FC-FIELD `LANG.603.$DATE` STRING></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'D'"-->
        <td><select name="FieldID:<FIELDID>=DATEDAY" onchange="RSD(<FIELDID>,-1,0,this.selectedIndex);">
                <option value="0"<!--#if expr="!$DAY"--> selected="selected"<!--#endif-->></option><!--#set var="DATE" value="0"--><!--#while expr="++$DATE < 32"-->
                <option value="<!--#echo var="$DATE"-->"<!--#if expr="$DATE == $DAY"--> selected="selected"<!--#endif-->><!--#echo var="$DATE"--></option><!--#endwhile-->
        </select></td><!--#endif--><!--#endwhile-->
        <input type="hidden" name="FieldID:<FIELDID>=DATE24HOUR" value="<!--#if expr="$YEAR"--><X-FC-FIELD <FIELDID> DATE,"%H"><!--#else-->0<!--#endif-->"/></td>
        <input type="hidden" name="FieldID:<FIELDID>=DATEMINUTE" value="<!--#if expr="$YEAR"--><X-FC-FIELD <FIELDID> DATE,"%M"><!--#else-->0<!--#endif-->"/></td>
        <input type="hidden" name="FieldID:<FIELDID>=DATEEND" value="1"/></td>
</tr>
</table>

Non-Indexed w/o Time, Date Required
to be replaced:         <FIELDID>

<table cellpadding="2" cellspacing="0" border="0">
<tr><!--#set var="FORMAT" value="<X-FC-FIELD LANG.7505.1 LITERALSTRING>"--><!--#if expr="!<X-FC-FIELD <FIELDID> DEFAULT=0 NUMBER>"--><!--#set var="YEAR" value="0"--><!--#set var="MONTH" value="0"--><!--#set var="DAY" value="0"--><!--#else--><!--#set var="YEAR" value="<X-FC-FIELD <FIELDID> DATE,"%Y">"--><!--#set var="MONTH" value="<X-FC-FIELD <FIELDID> DATE,"%#m">"--><!--#set var="DAY" value="<X-FC-FIELD <FIELDID> DATE,"%#d">"--><!--#endif--><!--#while expr="$FORMAT"--><!--#set var="CURFORMAT" expr="@split($FORMAT, ';')"--><!--#if expr="$CURFORMAT == 'Y'"-->
        <td><select name="FieldID:<FIELDID>=DATEYEAR"><!--#set var="CURRYEAR" value="<X-FC-SERVER-TIME FORM "%Y">"--><!--#if expr="!$YEAR"--><!--#set var="DATE" expr="$CURRYEAR - 6"--><!--#set var="ENDYEAR" expr="$CURRYEAR + 6"--><!--#elif expr="$YEAR < $CURRYEAR"--><!--#set var="DATE" expr="$YEAR - 6"--><!--#set var="ENDYEAR" expr="$CURRYEAR + 6"--><!--#else--><!--#set var="DATE" expr="$CURRYEAR - 6"--><!--#set var="ENDYEAR" expr="$YEAR + 6"--><!--#endif--><!--#while expr="++$DATE < $ENDYEAR"-->
                <option value="<!--#echo var="$DATE"-->"<!--#if expr="$YEAR == $DATE"--> selected="selected"<!--#endif-->><!--#echo var="$DATE"--></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'm'"-->
        <td><select name="FieldID:<FIELDID>=DATEMONTH"><!--#set var="DATE" value="0"--><!--#while expr="++$DATE < 13"-->
                <option value="<!--#echo expr="$DATE"-->"<!--#if expr="$DATE == $MONTH"--> selected="selected"<!--#endif-->><X-FC-FIELD `LANG.603.$DATE` STRING></option><!--#endwhile-->
        </select></td><!--#elif expr="$CURFORMAT == 'D'"-->
        <td><select name="FieldID:<FIELDID>=DATEDAY"><!--#set var="DATE" value="0"--><!--#while expr="++$DATE < 32"-->
                <option value="<!--#echo var="$DATE"-->"<!--#if expr="$DATE == $DAY"--> selected="selected"<!--#endif-->><!--#echo var="$DATE"--></option><!--#endwhile-->
        </select></td><!--#endif--><!--#endwhile-->
        <input type="hidden" name="FieldID:<FIELDID>=DATE24HOUR" value="<X-FC-FIELD <FIELDID> DATE,"%H">"/></td>
        <input type="hidden" name="FieldID:<FIELDID>=DATEMINUTE" value="<X-FC-FIELD <FIELDID> DATE,"%M">"/></td>
        <input type="hidden" name="FieldID:<FIELDID>=DATEEND" value="1"/></td>
</tr>
</table>