Date() Function

[Mksmall]

Is there a way to use criteria with the Date() function so that it will show only the last 2 digits of the year on a form?

 

[GingerR]

on the form, in the control's FORMAT property, put in

mm/dd/yy

(you can set it to SHORT TIME, and it might look ok on your computer, but it is dependant on how the user has their REGIONAL SETTINGS in their control panel set)

search in HELP for (copy this

Date fields, data display formats

you can see how mm, dd, yy, m, d, yyyy, etc work

g

 

[jebry]

Hi!

Use Format(Date(), "yy&quot

hth
Jeff Bridgham
bridgham@purdue.edu

 

[jebry]

Hi!

Use Format(Date(), "yy&quot

hth
Jeff Bridgham
bridgham@purdue.edu

 

[mscraig]

Check out the DatePart() function in the help files. It might fit the bill.