EndDate (Incorrectly shows the last day of the last month)

It correctly shows the start date of the last month. But the last day of last month does not show correctly

Hi kabdy,

What is your question?

Kilian Hekhuis wrote:

Hi kabdy,

What is your question?

 

 Hello I added an image there with an arrow indicated: it does not show the last day of the last month

Kilian Hekhuis wrote:

Hi kabdy,

What is your question?

 

 How can you fix this?

Hi Kabdy,

"EndDate" seems the output of the AgreementPeriod Action. I don't know what that Action does. How are we supposed to guess that?

Hi kabdygazinov,

I guess you will have to use the below mentioned expression statement to get the previous month - last date value

AddDays(NewDate(Year(CurrDateTime()), Month(CurrDateTime()), 1) , -1)


The above expression will return the value in DateTime format, if you simply require the Date value, use the conversion function as mentioned below 

DateTimeToDate(AddDays(NewDate(Year(CurrDateTime()), Month(CurrDateTime()), 1) , -1))


Hope this helps you!


Regards,

Benjith Sam