I hope someone can help me out. I have tried to figure this one out but can't seem to get my head around it.
Here it goes:
I have a Combo box called "Status". The combo Box contains 3 values. Low, Med, and High. The Combo Box defaults to Low which is what I need.
What I would like is that after 48 hours the status automatically changes from Low to Med, Then after a further 8 hours automatically update to the status of High.
At the same time I would like my text box which contains the date value to update accordingly. So 48 hours after the Case was created, then a further 8 hours to add to the case ect.
Currently the text box which hold the "Expected Resolution Date"uses the formula =DateSerial(Year([CaseOpened]),Month([CaseOpened]),Day([CaseOpened])+2). This only add the initial 2 days to the case.
Anyone with any suggestions??
I'd appreciate it.
Thanks
I
Here it goes:
I have a Combo box called "Status". The combo Box contains 3 values. Low, Med, and High. The Combo Box defaults to Low which is what I need.
What I would like is that after 48 hours the status automatically changes from Low to Med, Then after a further 8 hours automatically update to the status of High.
At the same time I would like my text box which contains the date value to update accordingly. So 48 hours after the Case was created, then a further 8 hours to add to the case ect.
Currently the text box which hold the "Expected Resolution Date"uses the formula =DateSerial(Year([CaseOpened]),Month([CaseOpened]),Day([CaseOpened])+2). This only add the initial 2 days to the case.
Anyone with any suggestions??
I'd appreciate it.
Thanks
I
