Change date format to yyyy in a combined field value within a query or form.

**Summit_IT** · 11-06-2023, 10:28 AM

I have a textbox in a form with the Control Source "="SH-OH-" & [DocumentYear] & "-" & [8130-3_ID]".

The result = SH-OH-10/31/2023 3:51:44-786.

I need result =SH-OH-2023-786.

Thanks!

**Bob Fitz** · 11-06-2023, 10:33 AM

Perhaps something like:

"="SH-OH-" & Year([DocumentYear]) & "-" & [8130-3_ID]".

**Summit_IT** · 11-06-2023, 10:47 AM

Hi Bob,

I get an invalid syntax error.

**Welshgasman** · 11-06-2023, 11:10 AM

Show us your version

**Summit_IT** · 11-06-2023, 11:11 AM

I figured it out.
The form was based on a qry. I used the Expression "Year: Format([DocumentYear],'yyyy')" and this fixed it.

Change date format to yyyy in a combined field value within a query or form.

Thread Tools

Change date format to yyyy in a combined field value within a query or form.

Similar Threads

how to change time format to yyyy/mm/dd in access 2016

Combine a date field in mm/dd/yyyy format with a text field to produce a field without the date /

I need to show date in format dd/mm/yyyy

Can access format a date in an odd way? DD-MMM-YYYY

Format options in combined Form field

Posting Permissions