I am preparing a report where I need a date to record as 1 Jul 1928.
I am using this SQL in the data field of the report.
=Format$([YearStart],"d mmm yyyy")
The field is in 'Date/Time' format in the database and shows as:
1/07/1928
The report gives me this error:
#Type!
What have I missed?
Many thanks,
Robin Chapple
__._,_.___
Posted by: Robin Chapple <robinski@westnet.com.au>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar