-Original Message-
> From: Michael Dinowitz <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Date: Monday, July 10, 2000 3:16 PM
> Subject: Re: IIf() and DE confusion
>
>
> >#IIF(IsDate(form.thedate), 'CreateODBCDate(form.thedate)', &
OTECTED]>
Date: Monday, July 10, 2000 3:16 PM
Subject: Re: IIf() and DE confusion
>#IIF(IsDate(form.thedate), 'CreateODBCDate(form.thedate)', '''NULL''')#
>
>Note the use of single and multiple quotes here in place of DE. Using DE
>instead will
Sorry, missed the use in the wrap. The code would actually be:
or
More information on this can be found here:
http://www.fusionauthority.com/IIF.cfm
> I know this can be done, but I'll be hanged if I can figure out the right
> combination of DE() and ## and quotes and whatever else might be
#IIF(IsDate(form.thedate), 'CreateODBCDate(form.thedate)', '''NULL''')#
Note the use of single and multiple quotes here in place of DE. Using DE
instead will look like one of these:
#IIF(IsDate(form.thedate), 'CreateODBCDate(form.thedate)', DE('NULL'))#
#IIF(IsDate(form.thedate), DE(CreateODBCDa
#x27;[EMAIL PROTECTED]' <[EMAIL PROTECTED]>
Date: Monday, July 10, 2000 2:25 PM
Subject: RE: IIf() and DE confusion
>This message is in MIME format. Since your mail reader does not
understand
>this format, some or all of this message may not be legible.
>
>--_=_NextPart_001
---
Bryan D. Batchelder Work: 813-935-7100
Palm/Internet Developer Home: 727-547-1322
ConnectWise, Inc. (www.ConnectWise.com)
2803 West Busch Blvd, Suite 204
Tampa, FL 33618
-Original Message-----
From: Jim McAtee [mai
I know this can be done, but I'll be hanged if I can figure out the right
combination of DE() and ## and quotes and whatever else might be needed.
I'm trying to use IIf() in a SQL statement instead of the following:
thedate = #CreateODBCDate(form.thedate)#NULL
Thanks,
Jim
-
7 matches
Mail list logo