Initial Date e Last day of month 

Initial Date e Last day of month 

  
Hello, Someone has already done or needed to create a date filter where the date starts on the 1st of this month and the other date field displays the last day of that month?
Or what expression OutSystems returns me the last day of the month:
example:

01/10/2013 - 31/10/2013
Hi Cleyton,

Without thinking too much.. I would say... create a date for day 1 of the following month and subtract 1 day

The following expression will return "31/10/2013"
AddDays(NewDate(2013,11,1),-1)
Regards

HD

Thanks Hélio for answering.

I had thought of that! but it does not work the way I expected! I'll try your approach ...

thank you!
Hélio Dolores wrote:
Hi Cleyton,

Without thinking too much.. I would say... create a date for day 1 of the following month and subtract 1 day

The following expression will return "31/10/2013"
AddDays(NewDate(2013,11,1),-1)
Regards

HD
 
Thank you again!

I solved the problem this way my end date

AddDays (AddMonths (NewDate (Year (CurrDate ()), Month (CurrDate ()), 1), 1), -1)

 
Great :)

Let me know if you need anything else.

Have a nice weekend!
I was going to post what Cleyton posted. :D

J.Ja