How to use both MonthStart() and Max() in Select in field

[#1]

Hello,

I choose the action Select in Field with the Field: "FrånDatum" and the Search String: ='(' & MonthStart(Max(FrånDatum)) & ')'

I have also tried to write the search string as: = MonthStart(Max(FrånDatum))

It works when i just write: =Max(FrånDatum) but i want to get the first day of the max date-month, not the max date.

Why canät i use both MonthStart() and Max()?

[marcus_sommer]

Monthstart returned a timestamp and not a date.I think you will therefore need something like:

date(floor(MonthStart(Max(FrånDatum))))

- Marcus

[HirisH_V7]

Hi,

check whether, your'e,Search String Expression, Working in 'TextBox' or not .

-Also check the Very first date of the month in your'e max date is present or not.

-Also,Check your'e Date formats,appearing in textbox and your'e selection List Box or column are same.

-Hirish