Date

[Guest]

Hello.
I wish to receive a result date in this form:
yy (06), only the two last numbersof the year.
The problem is i always receive it yyyy(2006), even if i change it to yy.
It's possible to solve this?

 

[Guest]

Nelson,

Is this from a query? From code? In a textbox?

Either way, you can use the Format function to display the date how you
want. Something like this:

Format(MyDateValueOrField,"yy")

Barry

 

[Guest]

Hi Barry.

I'm working directly on a form and using the builder expression. The retrive
is with format date. Altough, it retrieves me always yyyy. I've already
changed it to yy but nothing. In Excel it works.
By the way, i'm portuguese and i supose you're english, so i can't wish you
good luck tomorrow.

 

[Allen Browne]

Make sure you have *not* checked the boxes under:
Tools | Options | General | Use 4-digit years

Those settings override everything.

 

[Guest]

If you're using the Format property of a textbox, it should be a simple
matter of using yy. Are you using the format property or something else?

And yes, good luck tomorrow. I've moved on to the Tour de France and have
high hopes for the Americans.

Barry

 

[Guest]

Hi. It was not checked.

Any other ideas?

Nelson Silva


"Allen Browne" escreveu:

 

[Guest]

i'm using a textbox. But it's not a simpe matter of "yy". It doesn't work. In
Excel yes. Any other options?

I'm getting real desperate.

 

[Kevin K. Sullivan]

Brute force?

=Right(Format(MyDateValueOrField,"yy"),2)

HTH,
Kevin

 

[Guest]

sorry for the ignorance, but where do i write that message and i should write
it exactly like you have wroted it?

 

[Kevin K. Sullivan]

Select the textbox in form design mode.
Open the Properties and switch to the Data tab.
In the Control Source property, type:

=Right(Format(X,"yy"),2)

Replace the X with the name of the your field that stores the date. If
the field name has spaces or other special characters in it, like:

Date of Hire

....you need to enclose the field in square brackets:

=Right(Format([Date of Hire],"yy"),2)

HTH,

Kevin

 

[Guest]

Thanks My friend
--
Nelson Silva


"Kevin K. Sullivan" escreveu:

Select the textbox in form design mode.
Open the Properties and switch to the Data tab.
In the Control Source property, type:

=Right(Format(X,"yy"),2)

Replace the X with the name of the your field that stores the date. If
the field name has spaces or other special characters in it, like:

Date of Hire

....you need to enclose the field in square brackets:

=Right(Format([Date of Hire],"yy"),2)

HTH,

Kevin

sorry for the ignorance, but where do i write that message and i should write
it exactly like you have wroted it?