How to show only my available Dates in the "From Date" and "To Date" options?

[MuraliPrasath]

Hi,

I've created the "From Date" and "To Date". When I select the From Date it should show only My Available Dates. How to achieve this?

And I don't have Master Calendar in my dashboard.

[bimala0507]

If your available is kept in a column refer that instead of Variable

[tamilarasu]

Type like below in your list box expression property

=if(date(Date,'MM/DD/YYYY')>=date(vDateMin,'MM/DD/YYYY') and date(Date,'MM/DD/YYYY') <=date(vDateMax,'MM/DD/YYYY'),Date(Date,'MM/DD/YYYY'),null())

Here, vDateMin and vDateMax are variables, so adapt it as per your requirement.

Let me know, If you need sample application.

[HirisH_V7]

Hi,

please check the attachment .i hope this Helps.

[MuraliPrasath]

I understand this, but is there any way I can use this DATE field in MultiBox as a FROM and TO dates???

so that my users can select only the available dates instead of getting confused with other Dates.

Please suggest me!!

[tamilarasu]

Why not calendar!!! Calendar option is best for this kind of selection. Just check the attachment for better understanding.

!

[vishsaggi]

Hello,

PFA the sample file. Calendar object would be best option in this situation i believe.

Let us know if that works.

You date format assumed is: 'DD/MM/YYYY'.

Thanks,
V.