Can't Choose Field Properties on Query Fields

[tylerpickering]

Hi guys--



I'm pulling in data from a table and rearranging it (and a few other things) with my query. I want to make sure the output table is in the correct format (ex. currency, short date, etc).

I assume this is done by right clicking the field in the query and clicking properties, then selecting the correct format. I am able to do this for my first field, although it only gives date options. The other fields' field properties just show blanks and I cannot select them from a drop down.

Any ideas on what I'm doing wrong?

Thanks--attached is a screen shot!

[June7]

If the field is text type then no format options are presented. Options are offered for numeric fields (a date/time field is really a type of number data). You should see options for both of the date fields.

[tylerpickering]

Okay, that makes sense. One of the date fields gives me options, the second date field does not. Does it make a difference that quite a few of the 2nd date field are missing (but inputted as "---")? Maybe that changes it to a text field; is there a way to change it?

[June7]

Why would a date field show "---". Either it is a text field in table or it is a field created by an expression in query.

[tylerpickering]

Sorry, I didn't explain very well...my original data that's being pulled in from Excel has the "---" for dates that were not entered, it's not something that is pulled in by excel. Do I need to create a query that gets rid of these in order to create a proper date field?

Thanks!

[June7]

That or figure out why the import is populating with "---". Do you have to do this import periodically?

Could do a Find/Replace on the field to remove the "---" text. Then hopefully will be able to convert the field to date/time type.