Year Format

[Tansar]

Hi,
i have got my year format set as yyyy, which displays the year only. But when I click on the field it shows the full date.

This causes me a problem when concatenating two fields together, as I get the full date also. How do I solve this? I only need the year to show.

Thank you

 

[pbaldy]

When concatenating:

Year(YourDateField) & Whatever

 

[Tansar]

Erm...

My data type in my table is set as: Date/time. The format is set to yyyy. Yet I get a full date like 02/07/2008. I only need 2008

 

[CraigDolphin]

What Paul suggested will work. The function Year() returns just the year portion of the date. Format simply changes how the date is displayed, not what the underlying date value is.

The concatenation uses the value of the date, not the way it is displayed. So using the function Year() returns a value equal to the year portion of the date, and this can then be concatenated with whatever you want.

 

[Tansar]

Hmm...ok.

i have this:

EXPR1: [TM] & " " & [TRO_ID] & " " & [TRO_Year] & "/" & [TRO_Engineer]

Where would I add format to this?

 

[CraigDolphin]

You don't add format anywhere. I was simply explaining the difference between how the function Year() works versus formatting.

Assuming the field TRO_Year contains a datetime value:

EXPR1: [TM] & " " & [TRO_ID] & " " & Year([TRO_Year]) & "/" & [TRO_Engineer]

 

[Tansar]

Thanks guys!!