IMO, the code with IIF() would be more readable because it would be more compact.

ldStartOn = ldStartOn + IIF( VARTYPE(ldStartOn)=[D], 1, 86400)

>I have a fairly large module that contains a search routine that consists of a series of Loops inside loops, inside loops. Within the loops I have serveral places where I do comparisons such as:
>
>

>IF VARTYPE(ldStartOn)=[D]
>    ldStartOn=ldStartOn+1
>ELSE
>    ldStartOn=ldStartOn+86400
>ENDIF
>

>
>I like the code format for readability of the IF/ELSE/ENDIF, but I'm wondering if I'm doing myself a disservice in terms of speed. This code could be replaced with a IIF(). Since this module I'm looking at runs potientially 100+ times before it exits, I thought I might want to find out which way was better in terms of speed.
>
>Thanks for any input.
>
>Kirk