T
TKM
How do I take the dates that are different in the Effective Date field (see
bottom two dates) and incert them in the field named Start date. I know this
is redundant data but the tables have a lot more data to them and they have
been manually entered. So I must locate, sort extract then make a report
based on all this data. But for now I need to know how to do the below
everything a date if different in that series.
Start Date Effective Date
05/01/2001 05/01/2001
05/01/2001 05/01/2004
05/01/2001 06/01/2004
05/01/2001 05/01/2005
05/01/2001 05/01/2006
05/01/2001 06/01/2006
05/01/2001 07/01/2006
bottom two dates) and incert them in the field named Start date. I know this
is redundant data but the tables have a lot more data to them and they have
been manually entered. So I must locate, sort extract then make a report
based on all this data. But for now I need to know how to do the below
everything a date if different in that series.
Start Date Effective Date
05/01/2001 05/01/2001
05/01/2001 05/01/2004
05/01/2001 06/01/2004
05/01/2001 05/01/2005
05/01/2001 05/01/2006
05/01/2001 06/01/2006
05/01/2001 07/01/2006