J jason2885 Registered User. Local time Today, 08:17 Joined Jun 18, 2007 Messages 99 Jul 25, 2007 #1 I currently have a query that lists the date of something. I just need to have the year in which it is done for a task so I need to somehow find a way to write a function that will just show the year instead of the entire date. Any ideas.
I currently have a query that lists the date of something. I just need to have the year in which it is done for a task so I need to somehow find a way to write a function that will just show the year instead of the entire date. Any ideas.
M Michael J Ross Registered User. Local time Today, 16:17 Joined Mar 2, 2006 Messages 245 Jul 25, 2007 #2 Format([nameofdatefield],"yyyy")
J jason2885 Registered User. Local time Today, 08:17 Joined Jun 18, 2007 Messages 99 Jul 25, 2007 #3 Thanks for the help it works great.
