Copy link to clipboard
Copied
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>
nevermind. I had to apply Evalue(DE()) to the IIF paramater as follows and it is working:
<cfset vDate = iif(true, Evaluate(DE("vNow")), "")>
Copy link to clipboard
Copied
nevermind. I had to apply Evalue(DE()) to the IIF paramater as follows and it is working:
<cfset vDate = iif(true, Evaluate(DE("vNow")), "")>