G
Guest
Is there an expression I can use to take just the year from a date field on a
form and insert it into a text box on a report:
form and insert it into a text box on a report:
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Lynn Trapp
Format(YourDateField, "yyyy")
F
fredg
If the field is included in the report's record source:Is there an expression I can use to take just the year from a date field on a
form and insert it into a text box on a report:
=Year([DateField])
or..
=Format([DateField],"yyyy")
If the form control is not included in the report's record source:
=Year(Forms!FormName!ControlName)
The form must be open when the report is run.
G
Guest
The field is included in the report's record source. Thanks!!
fredg said:If the field is included in the report's record source:Is there an expression I can use to take just the year from a date field on a
form and insert it into a text box on a report:
=Year([DateField])
or..
=Format([DateField],"yyyy")
If the form control is not included in the report's record source:
=Year(Forms!FormName!ControlName)
The form must be open when the report is run.