Cannot format field in report in date format

I use a create table query to create a table from data in a form.
Two of the fields are date fields on the form, but when the table is created, these fields are stored in number format in the table. Then when I create a report from the table, the numbers are displayed in the report and I cannot format it in date format. There are only options to format as other variants of the number but not as a date.
Can anyone help please.
Fritz PaulAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mbizupConnect With a Mentor Commented:
In the textbox controls, just set the Format property to yyyy-mm-dd or similar (just manually type that into the format property).

It should automatically format the numbers to dates for you.
0
 
Dale FyeCommented:
What SQL are you using to create the make-table?  Dates are actually stored as double precision numbers, so I can see how they might translate to a numeric field in  a make-table.  You might try explicitly typing those fields, something like:

SELECT Field1, Field2, cDate(yourTable.Field3) as Field3
INTO yourNewTable
FROM yourFormQuery
0
All Courses

From novice to tech pro — start learning today.