Monthstart while selecting Month

[abhaysingh]

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

[remi_roland]

Hi,

You can use makedate function like this:

=makedate(YearField,Monthfield,01)

Regards.

Remi.

[#3]

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

[abhaysingh · Accepted solution]

monthstart(max(date)) works for me thanks

[mangalsk]

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

[susovan]

Hi abhay,

Try this expression,

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

[ziadm]

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 ..