Skip to main content
Inspiring
September 24, 2014
Answered

Date changed to default value when returned from IIF function

  • September 24, 2014
  • 1 reply
  • 274 views

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>

This topic has been closed for replies.
Correct answer aghanchi

nevermind. I had to apply Evalue(DE()) to the IIF paramater as follows and it is working:

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

1 reply

aghanchiAuthorCorrect answer
Inspiring
September 24, 2014

nevermind. I had to apply Evalue(DE()) to the IIF paramater as follows and it is working:

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