Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Want only 04 as date 2
- Thread starter pgtek
- Start date
-
1
- #2
danjausten
MIS
Use the totext function to format the date:
totext(Currentdate,"yy")
totext(Currentdate,"yy")
-
1
- #3
Keep the field as a date type - don't convert it to a number. Right click on it and choose Format Field. On the date / time tab choose the Customize tab. In the format area change the Month and Date to "None" and change the Year to "99" (or last two digits of the year).
Mike
Mike
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question