Forum

This content is now out of date.

Visit Our Community

Date Parameter ‘In Between’ function – consider leap year

Hi Team,

My report will show the data based on last one year. For this having a 'Date' field as filter value in my report.
That filter value defined like Date between 'CurrentDate - 1year' and CurrentDate.


Forum image


If the particular year is leap year, then how the calculation will be?
Whether it will consider leap day also (ie: CurrentDate-366 days) or it will execute like CurrentDate-365 days?

Please let us know how its implemented in Yellowfin. Also please update us how we can consider leap year also when its come into calculation.

Regards,
Chandrakumar.N.
Hi Chandra,

Leap year is an interesting question. I'm assuming that the calculation accounts for leap year, but let me double check with my team and get an official response.

I hope to have an answer to you soon.

Cheers,

Dustin

Best regards,

The Yellowfin Support Team

Contact Us:
Email: support@yellowfin.bi
Wiki: wiki.yellowfin.com.au/display/USER71/Home
Community Forum: www.yellowfinbi.com/YFForum.i4
Hi Dustin,

Is there any update on this?

Regards,
Chandrakumar.N.
Hi Chandrakumar,

Apologies for the delay on this forum post response.

When you apply filters as demonstrated in your previous post Yellowfin simply passes between filter syntax to the underlying database.

For example the following configuration setting:


Forum image


Is passed as the following SQL syntax:


Forum image

So really Yellowfin doesn't do anything 'special'... If a leap year date field falls in the filter range (i.e. 2015-02-29), it will simply be added to the result set.

Anyway, hopefully this clears up any confusion and apologies again for the delayed response. Please feel free to let us know if you have any questions or concerns.

Kind Regards,

Dustin
HI Dustin,

Thanks for the update. I will check and let you know if I face any issue.

Regards,
Chandrakumar.N.

Thanks for trying Yellowfin

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