End of Life Criteria - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

End of Life Criteria

Walter Hamilton

4 years ago

I have a form used to displace depreciable assets for the Home Office and for Customer Site. I have a calculated filed in the Record Source

EOL: DateAdd("m:,[LifeCycleMonths],[PurchaseDate]) which displays the date the item should be retired.

Everything works until I try to add the criteria that the EOL should be >Date()

I get and error that says

Data type mismatch in criteria expression

I'll attach a several screenshots as well.

	Walter Hamilton OP @Reply 4 years ago

	Walter Hamilton OP @Reply 4 years ago

	Walter Hamilton OP @Reply 4 years ago

	Adam Schwanz @Reply 4 years ago
Do it the other way, you may need to use 2 queries. One to sort the LifeCycle/Purchase Date to >Date() and the second one to do the DateAdd function on those already filtered fields.

	Walter Hamilton OP @Reply 4 years ago
Adam - Thanks. I'll try that.

	Walter Hamilton OP @Reply 4 years ago
Adam - I was able to get this to work by using the following criteria in the PurchaseDate field: >Date()-(([LifeCycleMonths]/12)*365) I always got an error when adding the >Date() Criteria to my EOL calculation.

	Adam Schwanz @Reply 4 years ago
I see, I'm not a fan of 365 because of leap year causing some silly stuff sometimes. (Maybe not in this case) What about trying DateDiff if we are just going to subtract them? DateDiff*

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View