Hi,
I need a marco that can check if a date & time entered is over 48Hours & if it is to delete the data in this row.
Example:
Time Set for entry is = 02/01/2014 12.00
After 48 Hours has expired > 04/01/2014 12.01
This row is deleted.
If the entry has not expired the row is to remain until it has expired.
There maybe up to a couple hundred entries, so manually checking is not ideal, but I believe a macro can do the trick just not sure how to setup the marco script.
Thanks in advance for your assistance
I need a marco that can check if a date & time entered is over 48Hours & if it is to delete the data in this row.
Example:
Time Set for entry is = 02/01/2014 12.00
After 48 Hours has expired > 04/01/2014 12.01
This row is deleted.
If the entry has not expired the row is to remain until it has expired.
There maybe up to a couple hundred entries, so manually checking is not ideal, but I believe a macro can do the trick just not sure how to setup the marco script.
Thanks in advance for your assistance