Date Mask not working

[Skip Bisconer]

I have I am doing a report on a query with two dates based on table and a different query, plus some other fields. The table is comprised of information created from a form of which one of the fields is a Delivery date and formated as a short dates from the form. The query is based on a table from my front end server.

My problem arises is this; The field from my front end server table represents an invoice date and is displayed for example, "000040810", representing 4/08/10.

When I query that field and do a Right("Field",6) function and use a short date mask and this displays in the query in short date format the way that I want.

However, I am unable toget this field to display in short date format in my report. Must I live with this or have I missed something? It looks hokey as one date shows 4/08/10 and the one right next to it shows 040810.

Thanks for any help or suggestions you may give me.

 

[CraigDolphin]

Not sure what all the extra zeroes are doing in your source table for a date field. However, if it were me I'd simply base my report on a query instead of directly on the table and convert the date in that query as you have already discussed. Or am I misunderstanding your problem?

 

[boblarson]

Doesn't the field from your query display properly on the report?

 

[Skip Bisconer]

Thanks for looking.

The report is based on the query with the two date fields. When I open the the query the Invoice date field (the one giving me problems) does display properly using the date mask. In the report it only dispalys the 6 digits without the mask even though I have set the field property in the report to a short date mask. I suspect the reason may be that my front end database that I am linking to the Invoice field property is set to Text and I am unable to change that.

 

[boblarson]

When you say:

set the field property in the report to a short date mask

are you doing this in the FORMAT property of the control on the report?

 

[Skip Bisconer]

Yes, when I couldn't get it to show correctly just from the reports query link I also added the mask to the date field property in the report.

 

[boblarson]

there is a difference between input mask property and the format property and you need to use the format property. What did you put in the format property?

 

[Skip Bisconer]

The format property for that field says short date.

 

[Skip Bisconer]

I solved my problem caused by date data coming from front end in text format. I created another field in the report query and in build did text functions Left 2 & / Mid 2 & / left, 2 on the date field and used the new field in the report.