I see a lot of comments about issues with calculated columns but this just seems too easy. Why does this not work?
Task.DateInitiated is a Date Attribute
Simple Calculated Column presents nothing
Simple Calculated Column presents nothing
V8.8
MySQL, AWS EC2, S3
PDFtk Toolkit
MySQL, AWS EC2, S3
PDFtk Toolkit
-
- Posts: 7523
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Simple Calculated Column presents nothing
You cannot use functions in calculated fields, unfortunately
Aware IM Support Team
-
- Posts: 297
- Joined: Wed Apr 22, 2015 11:44 pm
Re: Simple Calculated Column presents nothing
So why did using YEAR_DIFFERENCE(CURRENT_DATE, Participant.DateOfBirth) work for me then in a calculated column?aware_support wrote:You cannot use functions in calculated fields, unfortunately
Re: Simple Calculated Column presents nothing
We've used DAY_DIFFERENCE on a calculated column to output a number, works fine.
Maybe functions don't work on Date Type? Can you change Type to Plain Text, then make your calc:
AS_STRING(DATE_ADD(Task.DateInitiated,10) ?
Maybe functions don't work on Date Type? Can you change Type to Plain Text, then make your calc:
AS_STRING(DATE_ADD(Task.DateInitiated,10) ?
Rob . Aware 8.4 (build 2718), Developer Edition, using Linux, MYSQL
Re: Simple Calculated Column presents nothing
Yeah that works:
Rob . Aware 8.4 (build 2718), Developer Edition, using Linux, MYSQL