Hello world,
i want to create a CodeUnit to check 2 fields (Date) if they are empty, dont do anything, if not add 30Days and check if its >= the previous Field. after comparing send a mail message
Thanks for helping me
*This post is locked for comments
Hi
You can refer my blog, in the blog the code checks for the visa expiry date, if visa expires in a month then a email is send to the HR. you can code on similar lines
You're welcome!
Have a nice day to all :-)
Thank you so much Khoa Nguyen
I appreciate that
Always use FINDSET for REPEAT UNTIL
Hi Zakariia Bou,
It is same as a request from my customers. If Date of Expiry of one of two passports is going to be expired within 30 days, send an email to HR Staff to notify them.
LOCAL CheckSendToMail()
IF (Employee.FINDFIRST) THEN
REPEAT
IF (Employee."Echéance Passeport 1" IN [TODAY..CALCDATE('<+30D>', TODAY)]) THEN
SMTPMail.Send
ELSE IF (Employee."Echéance Passeport 2" IN [TODAY..CALCDATE('<+30D>', TODAY)]) THEN
SMTPMail.Send;
UNTIL (Employee.NEXT = 0);
check this link about CALCDATE
i created a Function (CheckToSendMail) and i put this :
LOCAL CheckSendToMail()
Employee.FINDFIRST;
REPEAT
IF
Employee."Echéance Passeport 1" <= CALCDATE('<TODAY+30D-1>')
THEN EXIT
ELSE
SMTPMail.Send ;
IF
Employee."Echéance Passeport 2" <= CALCDATE('<today+30D>')
THEN EXIT
ELSE
SMTPMail.Send;
UNTIL Employee.NEXT =0;
Did you try anything? Please provide what did you try and what issues are you facing.
thank you for responding.
my question is , how can i do that ??
what is your question now?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (