I have form where I enter name, address, city, phone and date of birth, image. So once I save the data through the form, I have trigger in the sql which will insert 2 more columns as Expiry Date, Auto Expiry date. The trigger will look for the month of the dob(date of birth) and from current year will add 5 years into it. For Example
Date of Birth: 1978-08-27
Current Year = 2018
Expiry Date = 'Aug 2023'
Auto Expiry Date = 2023-08-27
The issue is the data gets inserted but it doesn't update the front end field BUT DATE GETS INSERTED IN THE BACKEND. I am attaching the logic, snapshot.
I have 2 triggers
1. Insert - Issue
2. Update - Update tigger is working fine
Please let me know, If want to chat or talk over the phone or have WebEx/ Remote session.