How to get last day of month in monthfield in dropdown?

[Shubham_Deshmukh]

I'm trying wiht Monthend function but not getting an output.

Pls suggest.

[Anil_Babu_Samineni]

Where we need to help?

[vishsaggi]

You need this in a multibox? Can you share some sample data and where you are using this Monthend?

[Colin-Albert]

Monthend() returns a timestamp not a date. The timestamp is one millisecond before midnight.

To get the date value use floor(monthend(your_date_field))

How to use Monthend() | Qlik Community

[#5]

Monthend() function gives Timestamp as output. So just apply date() to you field and you will get the desired output

[arvind_patil]

Hi Shubham,

It may help you:

monthend(Date#(Datefield),' Your date Format like DD.MM.YYYY') as Monthdate;

Thanks,

Arvind Patil