topic Re: Monthstart while selecting Month in QlikView

Monthstart while selecting Month

abhaysingh — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to get the monthstart date after selecting month not Date, let say user select jun 16 than monthstart date shud come 01-06-2016

can i get this?

thanks

Re: Monthstart while selecting Month

remi_roland — Tue, 05 Jul 2016 07:16:39 GMT

Hi,

You can use makedate function like this:

=makedate(YearField,Monthfield,01)

Regards.

Remi.

Re: Monthstart while selecting Month

Tue, 05 Jul 2016 07:17:27 GMT

=date(floor(monthstart(today())), 'YYYYMMDD') FYR: How to get previous month first and last date?

Re: Monthstart while selecting Month

abhaysingh — Tue, 05 Jul 2016 07:21:15 GMT

monthstart(max(date)) works for me thanks

Re: Monthstart while selecting Month

mangalsk — Tue, 05 Jul 2016 07:23:24 GMT

=date(Date#(month_yr,'MMM YY'))

Re: Monthstart while selecting Month

susovan — Tue, 05 Jul 2016 07:30:26 GMT

Hi abhay,

Try this expression,

Date(MonthStart(Max(Date_Field)),'DD/MM/YYYY')

Re: Monthstart while selecting Month

ziadm — Tue, 05 Jul 2016 07:32:50 GMT

I am not sure how you can post a question at the same time answer your own question and get marks for that .. There is a vulnerabilities in the forum and must be reported ..