Date Format.... How Do I..? (1 Viewer)

[rdjohnso]

I have a report where I am trying to make the headers Jan - Dec of Current Year.. so the first coloumn header should show: January 06... but the '06'
needs to be dynamic in the se3nse that next year it should show 07.

Anyone have an idea how I can do this in a single cell?

Thanks in advance for any help.

 

[spacepro]

Create a textbox and set the controlsource to:

="Jan - Dec" & " " & Year(Now())

You can Hardcode the Jan - Dec and get the current year from today's date.

Hope this Helps
Andy

 

[Rich]

Set the display format of your date field to "MM/YY"

 

[rdjohnso]

Thanks a bunch Andy... that is very close to what I need....

Here's actually what I Put in....
="January" & " " & Format(Year(Now()),'yy')

Weird thing is.... when I do a preview for the report....
it says January 05... not 06... and Yes I checked and my
computer IS Feb06 so its not that... any ideas?

Thx agaibn for your help...

Ron

Create a textbox and set the controlsource to:

="Jan - Dec" & " " & Year(Now())

You can Hardcode the Jan - Dec and get the current year from today's date.

Hope this Helps
Andy

 

[spacepro]

Ron,

Put apostrophes not single quotes around the yy part of the format:

="January" & " " & Format(Year(Now()),"yy")


Andy

 

[rdjohnso]

I did that but doesnt make a difference..... this is a weird one.

Ron,

Put apostrophes not single quotes around the yy part of the format:

="January" & " " & Format(Year(Now()),"yy")


Andy

 

[spacepro]

Ron,

It works for me. Try creating a new report and put the etxtbox and enter the expression and see if it works. If it does then you must have some formatting on the textbox or report that is over-riding the xpression.

Double check on the Format property of the textbox to ensure it is blank.

See attachment.

Andy