Simple Calculated Column presents nothing

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
kklosson
Posts: 1617
Joined: Sun Nov 23, 2008 3:19 pm
Location: Virginia

Simple Calculated Column presents nothing

Post by kklosson »

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
Screenshot_4.png
Screenshot_4.png (24.15 KiB) Viewed 8130 times
V8.8
MySQL, AWS EC2, S3
PDFtk Toolkit
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Simple Calculated Column presents nothing

Post by aware_support »

You cannot use functions in calculated fields, unfortunately
Aware IM Support Team
Jhstephenson
Posts: 297
Joined: Wed Apr 22, 2015 11:44 pm

Re: Simple Calculated Column presents nothing

Post by Jhstephenson »

aware_support wrote:You cannot use functions in calculated fields, unfortunately
So why did using YEAR_DIFFERENCE(CURRENT_DATE, Participant.DateOfBirth) work for me then in a calculated column?
rob_h7
Posts: 85
Joined: Mon Jan 25, 2010 3:52 am

Re: Simple Calculated Column presents nothing

Post by rob_h7 »

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) ?
Rob . Aware 8.4 (build 2718), Developer Edition, using Linux, MYSQL
rob_h7
Posts: 85
Joined: Mon Jan 25, 2010 3:52 am

Re: Simple Calculated Column presents nothing

Post by rob_h7 »

Yeah that works:

Image

Image
Rob . Aware 8.4 (build 2718), Developer Edition, using Linux, MYSQL
Post Reply