1 Reply Latest reply on Sep 24, 2014 2:13 PM by aghanchi

    Date changed to default value when returned from IIF function

    aghanchi

      Hi,

       

      can anyone please explain why the vDate is being displayed as a decimal number in the following code. It seems that the IIF() functions returns  some default value and not what I set

       

      Thanks.

       

      <cfset vNow = DateFormat(Now(), "mm/dd/yyyy")>

       

      <cfoutput>

        vNow = #vNow# <br />

      </cfoutput>

       

      <cfset vDate = iif(true,  vNow, "")>

       

      <cfoutput>

        vDate = #vDate# <br />

        Formatted vDate = #DateFormat(vDate,"mm/dd/yyyy")# #TimeFormat(vDate, "hh:mm:ss")#

      </cfoutput>