Short Date (1 Viewer)

D

dogman01

Registered User.
Local time
Today, 00:54
Joined
Dec 3, 2008
Messages
47
I have a short date field but I would like to format a seperate text box that will only display the last 2 digits of the year. ie: 01/05/2009 = 09
 
pbaldy

pbaldy

Wino Moderator
Staff member
Local time
, 21:54
Joined
Aug 30, 2003
Messages
36,139
Try

=Format(DateField, "yy")
 
You must log in or register to reply here.

Similar threads

B
Using date from a text box in a where condition
Replies
6
Views
471
Pat Hartman
P
D
Solved Synchronising a List Box to a Combo Box
Replies
9
Views
764
davegoodo
D
K
Solved How to create a query that contains all dates?
Replies
10
Views
211
KitaYama
K
P
VBA query code to select a date between a start and finished date
Replies
5
Views
352
cheekybuddha
cheekybuddha
A
Extracting a date from Short Text
Replies
5
Views
594
alexfwalker81
A

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom