1

Re: Outputting Year value

I have created an XML Report to output a selection of records with the date downgraded to just year

The field syntax is "Year(SAMPLE.VAGUE_DATE_END) AS RecYear"

This works fine where the sample date is a day, but if the sample date is already a year then this creates a RecYear value which is 1 too many, e.g.
                 26/6/2011 - generated 2011
                 2011 - generated 2012

Any ideas where I'm going wrong?

Craig Slawson
Staffordshire Ecological Record

2

Re: Outputting Year value

Have a look at http://forums.nbn.org.uk/viewtopic.php?id=1636 ;)

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

3

Re: Outputting Year value

Brilliant, works a treat - just got to re-export all my data again, thanks Charlie

Craig Slawson
Staffordshire Ecological Record