[EMAIL PROTECTED] wrote:
Thanks, will try that.
What does the: % 100 do and what the Excel_date ?
The % is the modulus operator. It returns the remainder after division
by a number. For example, 1234 divided by 100 gives 12 and a remainder
of 34. The '/' division operator returns the quotient 12, and the %
modulus operator returns the remainder 34.
1234 / 100 => 12
1234 % 100 => 34
In hind sight I think the substr based version is clearer, bu this
version may provide higher performance due to ferwer format conversions.
You can try both and see if there is any measurable speed difference.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
