I am running CR X and Access 2003 database.

I have a table defined as Employee and one of the fields is called RESDate and is defined as Date/Time.

The RESDate has a default value Date () - 1. Bascially, I am deriving yesterday's date. When I view the table in Access, I see yesterday's date in the field.

Now in CR X:
I made a new connection and brought in this Access database and this one table. I moved the RESDate to detail line.

I do not see yesterday's date in CR. I did browse of the field in CR X and it shows blanks also. Any ideas ?

 

P.S.: I know in CR you can do DateAdd('d', -1, CurrentDate).  But I want to pull the date from the table. 

Thanks for your help in advance.

Regards
LB100

 

I was manually editing this table everyday and keying the date.  When I manually key the date, CR X works fine.   

 

So, I thought I would automate this process and use the Date () -1 in default value to derive at yesterday's date.

 

So, when I view the table in access, I see yesterday's date properly.

 

On CR X, it is not coming accross when I use Date () - 1.

 

Thanks and apprecite your 1st reply.

Regards

LB100

 

Under Access, Under Design Mode, create a new dummy attribute with Date/Time as Data Type. 

 

You will see at the bottom Field Properties. 

 

Under Field Properties, Under General, you will see Data Value.  Under Data Value is where I have "Date () - 1".

 

Once again, thank you for your time. 

 

Regards

LB100