Date Functions

[edieb]

I have a date function "Expr9: Choose(Month(Date()),7,8,9,10,11,12,1,2,3,4,5,6)" placed in a query that worked in Access 2010 and refuses to work in Access 2013. This expression allowed the month number for July to enter as number 1, August as number 2 and so on. July being the first month for the new fiscal year. What do I say different that will give the same results in Access 2013?

[ItsMe]

I am not finding anything on the web that suggests the choose function is not available in 2013.

The fact that you are using Expr9 as an alias causes me to believe that this query was imported into the DB before a supporting table was imported/available.

Right now, all that function does is return the current period. Is your function suppose to be related to a field in a table or the current month? The only other thing I can think would be to try dropping the parenthesis after date. don't really know though.

Maybe
Date
Instead of
Date()

[edieb]

The query is an append query. The expression is entering into a field. I would get a dialogue statement saying it was not a valid date expression.

[ItsMe]

Assuming the append to field is correct and your query is otherwise functioning, did you try dropping the parenthesis? I don't have 2013 so I can not test this.

[edieb]

Yes, I removed and added parenthesis. Unfortunately I don't have access to the database that we are updating to 2013 version at this time. I just have the 2010 on my desk top.

[ItsMe]

Yes, I removed and added parenthesis. Unfortunately I don't have access to the database that we are updating to 2013 version at this time. I just have the 2010 on my desk top.

SQL should require the parenthesis but I thought it might be worth a try. When you get to the 2013 version I would double check the query and make sure the append to field is good to go. Test the function in a test query based on a single copied table in the new version. You need to isolate the problem. Determine if it is the function or the query object.