H humph Registered User. Local time Today, 01:58 Joined Sep 7, 2006 Messages 69 Oct 13, 2006 #1 Hi folks - I saw a thread last week re how to extract the year from the date field possibly using date serial but can't find it can anyone help - it is probably very simple but i can't get it to work. Ta Humph
Hi folks - I saw a thread last week re how to extract the year from the date field possibly using date serial but can't find it can anyone help - it is probably very simple but i can't get it to work. Ta Humph
pdx_man Just trying to help Local time Today, 01:58 Joined Jan 23, 2001 Messages 1,347 Oct 13, 2006 #2 Try: Year(YourField)
E Ecron Registered User. Local time Today, 04:58 Joined Aug 31, 2006 Messages 58 Oct 13, 2006 #3 Right(txtDate,4) should do the trick. where it's 4 digits from the Right side? get it? 10/13/2006 would then equal 2006
Right(txtDate,4) should do the trick. where it's 4 digits from the Right side? get it? 10/13/2006 would then equal 2006
