06 Eylül 2012 Perşembe 19:50
I want to calculate the days left. I know I can't use [TODAY] in column. In a simple way, I would like to have a column name "Days left" and this column have to calculate this : expireDate-Today. But, I don't know how to do this. Somebody can help me please?
07 Eylül 2012 Cuma 06:49
I am not sure if this is what you are looking for, but here is the simple solution:
Create column 1 (let's say TODAY) and set column tyoe as date, with required set to yes and default value set to Today.
Create column 2 (EXPIRY DATE), type = date, enforced = yes
Create column 3 (DAYS LEFT), type calculated, formula you need is =[EXPIRY DATE]-[TODAY]
Hope this helps,
07 Eylül 2012 Cuma 12:49Thank you! I will try it :)