Kemidan2014
Board Regular
- Joined
- Apr 4, 2022
- Messages
- 226
- Office Version
- 365
- Platform
- Windows
I have a Query im using for a macro that exports the results to an excel file we use to graph the data since excel is more powerful until recently everything was working fine and it was discovered today it was explicitly outputting dates as 7/16/1905 for all records BUT! correctly outputing the records that are truly for the year we ask it to output. until today it put the correct issue date in the column when the export runs
a picture of todays results. the 24 stands for the year it was issued. 52-58 are all the ones we issued for this current year (confirmed by looking at actual back end table) but what was in Column B "Expr1" used to say "IssueDate" which is the name of the field for the Table
My QUERY for this used to say
FIeld: Expr: Year([IssueDate]}
Table: <blank>
Sort: <blank>
Show: Yes
Criteria: [Forms]![FrontPage]![evalyear] <~ This is a unbound field i have on a form for user to reference what year they need information from i use it for alot of other functions so we dont want to change this.
When i went to one of my older back ups it was BEFORE i added the year filter int he first place so if i go back to that it just gives you all records in the table
I tried doing this:
Result was NO records pulled
Here is the Table data for reference
Goal, i need Column B in my export to show the Issue dates associated with the records and not just "7/16/1905" or the year "2024"
any help is appreciated
a picture of todays results. the 24 stands for the year it was issued. 52-58 are all the ones we issued for this current year (confirmed by looking at actual back end table) but what was in Column B "Expr1" used to say "IssueDate" which is the name of the field for the Table
My QUERY for this used to say
FIeld: Expr: Year([IssueDate]}
Table: <blank>
Sort: <blank>
Show: Yes
Criteria: [Forms]![FrontPage]![evalyear] <~ This is a unbound field i have on a form for user to reference what year they need information from i use it for alot of other functions so we dont want to change this.
When i went to one of my older back ups it was BEFORE i added the year filter int he first place so if i go back to that it just gives you all records in the table
I tried doing this:
Result was NO records pulled
Here is the Table data for reference
Goal, i need Column B in my export to show the Issue dates associated with the records and not just "7/16/1905" or the year "2024"
any help is appreciated
