I am trying to calculate number of days items are in stock. so in excel formula would be: today() - Stock.indate.

I have two questions:

1) Is it possible to use creator to reflect Current date field in a column of a view. So it will always show the current date

2) In Creator's report, can i do a date calculation similar to excel  = today() - Datefield

Can you please provide some guidance.

Thanks,

DC Zhong