Last post Mar 07, 2017 09:16 AM by Cathy Zou
Feb 17, 2017 11:17 AM|okezievic2000|LINK
Feb 20, 2017 05:37 AM|Cathy Zou|LINK
From your description, it is hard for me to understand your problem and what is your needs.
Would you please provide me with clear description about your problem or some code you have done.
Feb 20, 2017 09:24 AM|okezievic2000|LINK
Thank You Cathy. I am yet to write the code, as I am at a cross road on how to deal with datetime functions. but simply put it in these scenario:
For a staff to be promoted to the next level (Say from level 8 to level 9), he or she must have stayed up to 3 years in the present level, before he or she can be qualified for promotion to the next level), Which to say, if the year is 01/02/2017 (or any
date, within the year), all the staff being entered for promotion, must have been up to three years or more in the present level, before the said date being worked on (i.e 01/02/2017).
Mar 07, 2017 09:16 AM|Cathy Zou|LINK
For your problem, I suggest you could use the system function DATEDIFF in Access.
the staff ID is 123456,
SELECT IF(DATEDIFF("yyyy", [TheDateInCurrentLevel], DATE()) >= 3, 1, 0) AS [Result] FROM [StaffTable] WHERE [StaffId] = 123456