Forum

This content is now out of date.

Visit Our Community

Problems with using WEEK() function

Hi,

I'm trying to use a freehand SQL field with the WEEK() function: WEEK(datefield,3)

I've used this before with success on certain other table fields but in this case when I try to save/activate the field in the view builder it keeps loading and at one point gives a timeout.

Thanks,
Jaap
Hi Jaap,

Can you please provide;

-Database you're reporting against
-Version of Yellowfin (including build version from 'system information')
-Raw data and expected result when querying the DB directly (outside of YF)
-How you're applying this query in YF (showing view builder etc..)
-log files under Yellowfinappserverlogs and let me know roughly what time you're trying to save the field.

Also , do you get the same problem if using a virtual table, or a freehand sql calc field at the report level?

Please let me know your findings.

Regards,
David




Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.