Distinct

[#1]

Hi,

Is it possible to use the Distinct function in the Expression of the calender object.

Regards,XXX

[#2]

[#3]

Hi,

If the function in your expression have the option [DISTINCT], you can use but what problemn do you have?

[#4]

Hi,

i have created the calender control from the feild with the Expression =Makedate(Year(AT),Month(AT),Day(AT)).

In the calender control the date is not displayed If i select the date from the drop down of the the calender control or the select the date from calender table.

any one can help me to find the solution??????????????

Regards,XXX

[#5]

Do you can post a file whith this example?

[suniljain]

yes, You can use distinct function in Expression . But Can I know your exact requirement ?.

Regards

Sunil

[#7]

I think you need use a field AT with a full date, and not make a date with 3 fields?

Do you have a field date or you remove in your script....

I use year,month and day separated just the user can select with granularity.....but on the calendar object i use a full date!!!

Did you try that?

[#8]

Thanks for your response

@ Sunil i am not able use the Distinct option in Expression. Please see the Attachment.

@ Alexio i tried the full date as well. Since the field i am using is with datetime format hence there are duplicates of the same date. Hence i used the makedate function.