Re: Joy and dbo.LCReturnVagueDateShort
Just unravelling the reporting of vague dates - not for the first time I should add, but this time I'm determined to CRUSH the issue out of existence.
Any road, using dbo.LCReturnVagueDateShort (see - http://forums.nbn.org.uk/viewtopic.php?id=305) seems to be lovely, except when vague_date_type = 'M'
In this instance, the value returns NULL. Which is odd, considering all other VDTypes return what would seem to be appropriate values, even the seasons!
Ive checked the Sample Keys and they seem to exist as months only in recorder which is fine.
Can anyone confirm this behaviour and/or solve the mystery?
select dbo.LCReturnVagueDateShort(sample.vague_date_start,sample.vague_date_end,sample.vague_date_type) as Recorder_date
from sample
where sample.vague_date_type = 'M'
I'm SO close to joy!
M
Tullie House Museum