Skip to Content (Press Enter)
2020-06-26 10-11-24
kan2332
190Views
5Comments
EndDate (Incorrectly shows the last day of the last month)
Question

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

0
0
24 Jul 2020
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Hi kabdy,

What is your question?

0
0
24 Jul 2020
Copy Link
2020-06-26 10-11-24
kan2332

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

0
0
24 Jul 2020
Copy Link
2020-06-26 10-11-24
kan2332

Kilian Hekhuis wrote:

Hi kabdy,

What is your question?

 

 How can you fix this?

0
0
24 Jul 2020
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

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?

0
0
24 Jul 2020
Copy Link
2021-03-18 21-03-15
Benjith Sam
 
MVP

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

0
0
24 Jul 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.