Hi
I want when run the form then :
1- if the day for date will be 27 or 28 or 29 or 30 or 31 for current month (DEC) and the column A will not be current month for current year DEC-24 should show message"You have to settle your salary entitlement."
2- if the day for date will be 27 or 28 or 29 or 30 or 31 for current month(DEC) and the column A will be current month for current year DEC-24 then shouldn't show message.
3- if Exceeded days 27 or 28 or 29 or 30 or 31 previous month )(DEC) like 1 , 2 , 3.... for current month and current year JAN-25 and there is no month DEC in column A then show message "you have missed month is DEC to settle your salary entitlement"
when there is missed month in column A then should show message to inform me what's the months are missed in any day for date .
but everything is ok then just show message for current month based on any day 27 or 28 or 29 or 30 or 31.
thanks
I want when run the form then :
1- if the day for date will be 27 or 28 or 29 or 30 or 31 for current month (DEC) and the column A will not be current month for current year DEC-24 should show message"You have to settle your salary entitlement."
2- if the day for date will be 27 or 28 or 29 or 30 or 31 for current month(DEC) and the column A will be current month for current year DEC-24 then shouldn't show message.
3- if Exceeded days 27 or 28 or 29 or 30 or 31 previous month )(DEC) like 1 , 2 , 3.... for current month and current year JAN-25 and there is no month DEC in column A then show message "you have missed month is DEC to settle your salary entitlement"
when there is missed month in column A then should show message to inform me what's the months are missed in any day for date .
but everything is ok then just show message for current month based on any day 27 or 28 or 29 or 30 or 31.
thanks
