title: VBscipt date format
body: <p>This is my query.</p>
  
  <pre><code> strSQL = "Select task,to_char(ddat,'dd/mm/yyyy') as ddat from task where guid = '"&amp;lvGuid&amp;"'"
          'Response.write strSQL
          objRS.Open strSQL, objConn
  
              If objRS.RecordCount &gt; 0 Then
                  strTask = objRS("task")
                  strDate = objRS("ddat")
              Else
                  strTask = ""
                  strDate = ""
              End If
  </code></pre>
  
  <p>This is the form that show that i wanted to display a text area if the people is finish their task after due date for asking the reason. But the problem is the <code>if else statement</code> cannot be run. The program not display the <code>textarea</code> when the person is over due date.</p>
  
  <pre><code>&lt;form name="form1" method="post" action="taskconfirm.asp" &gt;
  
      &lt;h2&gt;Ticket : &lt;input type="text" name="txtTask" value="&lt;%=strTask%&gt;" style="height:35px; font-size: 18pt; border:none;" readonly&gt; &lt;/h2&gt;
  
      &lt;p&gt;Today's Date: &lt;%=Date()%&gt;&lt;/p&gt;
      &lt;p&gt;Due Date: &lt;%=strDate%&gt;&lt;/p&gt;
      &lt;p&gt;By reaching to this link, you have completed the ticket above. Please click the button below to confirm&lt;/p&gt;
      &lt;br&gt;
      &lt;!-- ASP IF ELSE CONDITION HERE DATE - OVERDUE --&gt;
          &lt;%If Date() &gt; strDate then %&gt;
          &lt;%response.write("Please give a reason for ticket overdue :")%&gt;&lt;br/&gt;
          &lt;textarea type="text" name="txtreas" rows="4" cols="40" id="txtareaId"&gt;&lt;/textarea&gt;
          &lt;%end if%&gt;
      &lt;input type="submit" name="txtConfirm" value="Confirm" "&gt;
      &lt;/form&gt;
  </code></pre>
  
  <p>I feel appreciate for anyone trying to help.Thanks a lot.</p>