RunTime: Custom Format VS. function

[barbarossaii]

Hello,

what's faster:

"Custom Format" in the Design View: VIEW, then PROPERTIES. setting for example "YYYY"

or

the built in functions: funtions that will return part of a date. i.e. Year([Field containing DOB]) ,......



when 'manipulating' dates ?



(I deal w/ tables w/ 300 000, 20 000 & 10 000 records / Date fields.)

TIA,
Barbarossa II

 

[Mile-O]

Make up your own mind with this:

 

[barbarossaii]

Thanx Mile-O-Phile !

Barbarossa II

(on my computer the "year"-function is faster than "format")

 

[Mile-O]

As it should be...

 

[barbarossaii]

Why obvious ?

Why was it obvious to you that the one is faster than the other,

Barbarossa II

 

[Mile-O]

The Format() function does a lot more than the Year() function.

Year() returns an integer value that's basically extracted from the date.

Format() returns a string value - so there's conversion in there too - but in its process it's looking at the information you've given it and trying to present that data. It understands a lot of different format types, too.