on the desingh view of my qwery that shows endindDate(end) and description(des c)
i added the following:

Code:
exp1: DateDiff( 'd',Date(),[end])
so that each time the query runs to autocalculate how many days left from the end date until today

my problem is that i get invalid syntax erro and it marks my first comma

at first i thought it was the current date naming and i have also tried todaysdate,curD ate...