Changing Date value 1

[kpryan]

Hi all,
Is it possible when a date is typed into a date field ie: 1/2/08
That the field only shows the day ie: 1st and not the month or year.

many thanks,

Ken

 

[SkipVought]

Are you referring to entering data directly into a TABLE or a FORM? You are int the Forms forum and you could use the Format function or the Day Function to DISPLAY the day for a particular date.

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[kpryan]

Hi SkipVought
Thanks for your reply. Yes its for a form. I though it might be the day function. I did try it, but could not get it to work.

Ken

 

[jordanking]

sure, but if that field is bound to a table you will need to adjust your form design. make the date field that is bound to the table invisible, then create another visible unbound date text box. Then you can capture the full date value and put it in the invisible text box and reformat the visible one to only show the day with FORMAT() function. THen update this event every time the visible date box changes or loses its focus.

.....
I'd rather be surfing

 

[TheAceMan1]

How are kpryan . . .

In form design view, change the [blue]Format[/blue] of the field to [blue]dd[/blue] . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886