Calendar Date Logic

Q&A
, , ,
1

Hello Quick Sight’ers

Fairly new to Quick Sight. I have a question on Calendar date. Is there an option in the Date Picker, when the calendar shows up it shows only until today’s date and masks the rest of the days. Would be great if there is an option.

If anyone has any alternate solution and can share, would be awesome.

Thanks
Cheri

2

Hi @Sree2025 and welcome to the Quick Sight community!
The date picker parameters and controls are fairly limited in additional feature options, currently there is not an option to hide dates past ‘today’.

I’ll mark this as a feature request to promote visibility to the support team.

Thank you

3

Thank you. Since that feature is not there, I thought of having a field check on the date field. Created a calculated field BusinessDateError: (ifelse '${businessdate) >= truncDate(“DD”, now()), ‘! Business date Cannot be in future’, ’ '). I have been trying to connect it to the input Controls field “Business Date” , so that as soon as the user inputs a future date, it pops out the error. In my earlier days(eons agon), in Oracle Forms you could do it easily as a trigger in the field. Tried chatGPT but not giving a proper solution
. Any simple way to do this?

Thanks again
Sree

4

Hi @Sree2025

You may not be able to popup a message. But if you created that as a calculated field you may show it in a visual with Red text or something to make your users aware.

Regards,
Giri

1 Like
5

Hi @Sree2025,
Following up here to see if you had any additional questions, if you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

6

Hi @Sree2025,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you