hello friends,
please help, my boss want me to make a reminder due to expiry date of our license.
the alert must be based on (the expiry date - 10), and the pop up will display the No.License.
the expiry date is in column I
No.License is in column F
<colgroup><col width="27"><col width="47"><col width="154"><col width="258"><col width="64"><col width="231"><col width="73"><col width="101"><col width="72"><col width="71"><col width="90"><col width="73"><col width="287"><col width="86"></colgroup><tbody>
</tbody>
Tks in advance
please help, my boss want me to make a reminder due to expiry date of our license.
the alert must be based on (the expiry date - 10), and the pop up will display the No.License.
the expiry date is in column I
No.License is in column F
NO | SECTION | INDEX | NAME | ISSUER | NO. LICENSE | I/L DATE | QUOTA | EXPIRES | NOTIFY | SUBMISSION | Renewal L/T | PROGRESS / REMARKS | REMARKS |
<colgroup><col width="27"><col width="47"><col width="154"><col width="258"><col width="64"><col width="231"><col width="73"><col width="101"><col width="72"><col width="71"><col width="90"><col width="73"><col width="287"><col width="86"></colgroup><tbody>
</tbody>
Tks in advance