I have a report where I prompt for a user to enter a date that will be used on a letter that is generated and I need to learn how to convert the date they enter when prompted when opening the report to mmmm dd, yyyy. My big issue is that this is part of a concatenated text box below. Does anyone know hoe to do this?
"The NCDoI has sent notification that as of " & I Need to convert the date here. & " you have not met your Continuing Education requirements."
I have converted the date in its own text box and have tried referring to that text box that is converted and it does not work.
"The NCDoI has sent notification that as of " & I Need to convert the date here. & " you have not met your Continuing Education requirements."
I have converted the date in its own text box and have tried referring to that text box that is converted and it does not work.