IIF() is faster that IF...ELSE...ENDIF.
Try this: ldStartOn = ldStartOn + IIF(VARTYPE(ldStartOn)=[D],1,86400)
Hope this helps.
>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
Dennis Lindeman