I think I have looked at this too long and I feel retarded.
I have these variables:
TodaysDate = Date
LastUpdateDate = input by user
Interval = input by user in days
NextUpdateDate = LasterUpdateDate + Interval
GreenDate = NextUpdateDate + 14
I need to do some if statements for 3 outputs.
Output as 3 (represents green)
Output as 2 (represents yellow)
Output as 1 (represents red)
The user will only input lastupdatedate and interval, the interval would be in days always.
If the nextupdate date is in the next 14 days of the current date, i need the output as 2(yellow).
If the nextupdate date is more than 14 days away, the output needs to be 3(green)
Otherwise, the nextupdatedate is today or already past, the output is 1(red).
My brain just hurts and i know im so damn close, can someone look at this for me?
Bookmarks