format time/date

[racerrunner]

Hi all,

i've a field that contains the systemdate n time
i.e
txtDate.value = Now

will give me this 11/30/1899 9:46:00 AM.

How do i get rid of the second hands??

i want 11/30/1899 9:46 AM instead.

Thank you

 

[rborob]

in the field description on your table, click the input mask and the thre ...'s ate the end. then select "short time"

 

[allan57]

You can also use the format function to display your date/time in whatever style you choose.

txtDate.value = format(now(), "dd/mm/yy hh:mm AMPM")

 

[rborob]

yeah..what he said

 

[raskew]

Hi -

There's something very wrong here. Try this from the debug (immediate) window:

x = now()
? x
6/16/06 4:41:47 AM

If this is an Access issue, your date/time will be different, depending on when you perform it, but it certainly won't be: 11/30/1899 9:46:00 AM.

We need more info. Is this perhaps an Excel problem?

Bob