Taking the last day of the month in Date and Time Field

(0) Share

Report

Posted on by Mravcho

We have a Calculated Field with Data Type:Date and Time (let's call it Y) . The value is based on another Date and Time field (X) and it needs to be the last day of the next month. For example

X = 12.4.2021, i need Y=31.5.2021

Version 1612 (8.2.1.176) (DB 8.2.1.176) on-premises

Can we do that?

I have the same question (0)

All responses (2)

Answers (0)

Pradeep Rai 5,489 Moderator on at

Like (0)

Report

Hi,

If calculated field creation is not mandatory then

I would suggest to use some other business logic like Plugin, Script etc.

These approach will be easier one.

Thanks,

Pradeep.

Was this reply helpful? Yes No
Esteban Coto Alfaro on at

Like (0)

Report

Hello, I recommend you to do something like this in JavaScript, this does not require any library:

var date = new Date();

var lastday = new Date(date.getFullYear(), date.getMonth() + 1, 0); // the + 1 in the month refers to the actual month, if you want the last day of the next month you must put + 2.

Thanks!

Community Support Team - Esteban

If this Post helps, then please consider Accept as solution to help the other members find it more quickly.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Taking the last day of the month in Date and Time Field

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Taking the last day of the month in Date and Time Field

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates