Date field to show only year

attardc

I added a new field to the item card - Year of Manufacture of type Date. I need to store, or at least show only the year (2008) not the whole date. Is this possible in any way?

thanks a lot

kine

You can use the FORMAT function to format the output just to the Year. Or you can use the OnFormat trigger to format the output...

kriki

[Topic moved from Navision Tips & Tricks forum to Navision forum]

Savatage

go to the field on your form thru designer. View Properties
change SourceExp to

FORMAT("Your Date Field",0,'<year4>')

The table will store the whole date - but the display will just be the year.

garak

the format function is to see, if you will store only the year, and also in filter need only the your (only see 2000, 2005 ...), u can use the function

"Your Field" := DATE2DMY(YOURDATE,3);

Regards

Savatage

might as well pile on
How about just a 4 digit Integer field or text field
screw the whole date thing.