Count dates between dates

Hello Byron Burton,

My name is Sharwari Inkane from the Yellowfin Technical Support Team. We have received your support request, and I will be your primary contact on the following ticket:

Ticket Number: #30073
Case Title: Count dates between dates

Allow me some time to look into this. I will get back to you with my findings as soon as possible.

Sincerely,

Sharwari Inkane

Yellowfin Technical Support Engineer

Hello Byron Burton,

I have reviewed your request and found that you can achieve this using a predefined function available in the calculated field. I've included a video for your reference.

https://ftp.yellowfin.bi/f/f4cd14d20f643fed

I would like to recommend go through the below link. It contains information related to Calculations.

https://wiki.yellowfinbi.com/display/yfcurrent/Calculations#Calculations-Pre-DefinedFormula

Please let me know if this helps.

Regards,
Sharwari Inkane

I tried that and it did not work. One column has the date and time. 08/08/2024 12:00 AM

The other column only has the date. 08/08/2024

Hello Byron,

I have also tested it with different formats- one column containing date and time, and the other with only the date and it still works for me. Please check the video recording of my replication below.

https://ftp.yellowfin.bi/f/c6d8d22d076afa9a

If you'd like, we can schedule a remote session to discuss this issue further based on your availability. I am available from 6:00 AM to 12:30 PM IST, Monday through Friday. Please confirm your availability so we can send you an invitation.

Regards,
Sharwari Inkane

I found out it has to do with restrictions on the company who created the database. I will take another approach. You can consider this closed.

Hello Byron,

Thanks for the confirmation. I will now go ahead and mark this case as completed. If you have any other issue please contact us again by opening up a new ticket and we will provide additional support.

Have a great rest of your day!

Regards,
Sharwari Inkane