Calendar Date Logic

Question & Answer
, ,
1

Hello QuickSight’ers

Fairly new to QuickSight. 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 QuickSight 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