Thank you for your assistance.
The dates come from an SQL datebase (MQ SQL) .
CreatedDate is an SQL column of type datetime.
I also have [Created On] which is loaded from CreatedDate by Date(CreatedDate, 'YYYY-MM-DD') as "Created On",
Based on what you said I decided to use [Created On] instead and that works.
I do not know why CreatedDate did not work, it displays as a date and time etc.
So I reverted back to what I did in the beginning Today(1)-CreatedDate and now that works.
To get whole days I added a floor, floor(Today(1)-CreatedDate) and that is working now.
Maybe I has some other error that I did not recognize in the very first attempt.
There is no "Date difference" (DateSub) function.
the date difference is just a math subtraction
this is the difference between today and the beginning of the year
today(1) - MakeDate(2016)
maybe your CreateDate is not a date
and you need a format to interpret your CreateDate