This is a date question...
Here is what I am trying to do.
I have two columns. The values in the first column, let's call them Begin
Date.
The values in the second column we will call End Date.
What I am trying to do is creat (in a third column) a Yes or No value based
on the
following criteria:
If (amount of time) between Begin Date and End Date is less than 1 week,
put a value of Yes in the third column for this record. If not, put a No.
Can this be done?
--
RSF
|