UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> exclude year from date    
 
   
wsloan311
post Dec 4 2007, 11:14 AM
Post #1

UtterAccess Addict
Posts: 126
From: Dallas, TX
On a report, I want to just show the month and day (for a birthday list). How do I format to exlude the year?
Thanks.
Go to the top of the page
 
+
MattJ
post Dec 4 2007, 11:16 AM
Post #2

UtterAccess VIP
Posts: 4,621
From: North Carolina, USA
Format([YourDate],"mm/dd")

HTH
Matt
Go to the top of the page
 
+
dashiellx2000
post Dec 4 2007, 11:16 AM
Post #3

UtterAccess VIP
Posts: 9,209
From: Maryland
Use the Format Function as part of the control source of the control in question.

HTH.
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 03:04 PM