appc
asked on
How do I change the format of a query field?
Hi everyone,
I am creating a simple query that takes a list of clients with additional related information. Among the fields that I am adding into my query, one field contains dates that do not have a date format.
Their current format is YYYYMMDD but Access does not recognize it as a date.
How can I use the query so that my dates become actual dates in Access(so that I can compare these dates with the actual current date)?
Thank you!
I am creating a simple query that takes a list of clients with additional related information. Among the fields that I am adding into my query, one field contains dates that do not have a date format.
Their current format is YYYYMMDD but Access does not recognize it as a date.
How can I use the query so that my dates become actual dates in Access(so that I can compare these dates with the actual current date)?
Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER