How to format a date field in an expression within a query in Access 2010
Does anyone know how I can format the below [Start Date] to a long date?
Employment start date: "1.1. Your employment will commence on " & [Start Date] & "."
Employment start date: "1.1. Your employment will commence on " & [Start Date] & "."
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.
Just to add, Lilly take a look at the on-line help for the format command or use this as a start:
https://support.office.com/en-us/article/Format-Function-6f29d87b-8761-408d-81d3-63b9cd842530
Format() is used for all kinds of things such as dates, times, dollar values, numbers, generating literal characters, yes/no values, etc. For numbers, It mas multiple sections so you can specify formats for positive numbers, negative numbers, format to use when zero, etc.
Jim.
https://support.office.com/en-us/article/Format-Function-6f29d87b-8761-408d-81d3-63b9cd842530
Format() is used for all kinds of things such as dates, times, dollar values, numbers, generating literal characters, yes/no values, etc. For numbers, It mas multiple sections so you can specify formats for positive numbers, negative numbers, format to use when zero, etc.
Jim.
ASKER
Thanks Jim, that really useful :)
ASKER