I IanT Registered User. Local time Today, 03:43 Joined Nov 30, 2001 Messages 191 Jul 29, 2010 #1 Can anyone advise how I could, by giving a date find the start date of the year. For example: Date Result 30/06/2010 01/01/2010 14/12/2008 01/01/2008 Probaly simple!!!! Thanks in advance.
Can anyone advise how I could, by giving a date find the start date of the year. For example: Date Result 30/06/2010 01/01/2010 14/12/2008 01/01/2008 Probaly simple!!!! Thanks in advance.
N nathansav Registered User. Local time Yesterday, 19:43 Joined Jul 28, 2010 Messages 114 Jul 29, 2010 #2 dateserial(year(date),1,1)
