Extracting info from date fields

[SM76]

Mornin .. I was wondering if anybody knows a way to extract the four digit year from a date-field.

Reason I'm doing this is because I have a calculation that creates file references to images that have a file-name that includes that year ...

Appreciate the help ..

SM

[comment]

Year ( Datefield ) will extract the year.

If you have records going back to before year 1000, and you want to pad the result with zeros, use:

Right ( "0000" & Year ( Datefield ) ; 4 )

[Stuart Taylor]

Calculation result as number

Year ( date )

[SM76]

that was easy .. thanks