I have a field, PERIOD_ID, that is in a text format, I am trying to convert this into an actual date format:
an example of what the data looks like in this field is 0208 this correspondes to August 2002.
I have tried the format function by doing this:
format((mid([period_id],3,2) & 20 &...
Scenario:
Oracle Database, ACcess 2000 front end. User fills out a form to prepare information that is passed to a query. The query gets 4 pieces of information from the form, these are:
cbo_app - application
cbo_inst - institution
cbo_src - source
cbo_grp - product group
These 4 parameters...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.