How to update 'End date' field to automatically to set to current month end date in flow designer

[lakshmi_laksh]

Hi,
I am having requirement, the end date field should automatically set to last date of month it was updated..
tried this script, not working..
Thanks in advance..

var currentDate = new GlideDateTime(fd_data.trigger.current.end_date);

var time = currentDate.getDayOfMonthUTC();

return time;

[Satishkumar B · Accepted solution]

@lakshmi_laksh try the below code. i have tested the same:

var gd = new GlideDateTime();
gd.setValue('2024-08-08');
gd.addMonthsUTC(1);
gd.setDayOfMonthUTC(1);
gd.addDaysUTC(-1);
gs.info(gd);

…………………………………………........................................................................................
Mark it helpful 👍and Accept Solution ✅!! If this helps you to understand.

…………………………………………........................................................................................

[HIROSHI SATOH · Accepted solution]

Why did you change this code?
gd = fd_data.trigger.current.end_date; // Get the current end date

[Sid_Takali]

Hi @lakshmi_laksh Try below code

    var currentDate = new GlideDateTime();
    var glideDate = new GlideDate();
    glideDate.setValue(currentDate.getDate().getDatePart());
    glideDate.addMonths(1);
    glideDate.setDayOfMonth(1);
    glideDate.addDays(-1);
    var endOfMonthDate = new GlideDateTime(glideDate.getValue());
    gs.info("The last day of the month is: " + endOfMonthDate.getDisplayValue());
    
 

[HIROSHI SATOH]

Is this sample code helpful?

var gd = new GlideDateTime();
gd.setValue(fd_data.trigger.current.end_date); // Get the current end date

// Calculate the last day of the month
gd.addMonths(1); // Go to the first day of the next month
gd.addDaysUTC(-1); // Subtract one day to get the last day of the current month

// Set the calculated date as the new end date
fd_data.trigger.current.end_date = gd;

[lakshmi_laksh]

Hi @HIROSHI SATOH 
I tried below , its throwing an error

var gd = new GlideDateTime();

gd = fd_data.trigger.current.end_date; // Get the current end date

gd.addMonths(1);

gd.addDaysUTC(-1);

fd_data.trigger.current.end_date = gd;

return gd;

[HIROSHI SATOH · Accepted solution]

Why did you change this code?
gd = fd_data.trigger.current.end_date; // Get the current end date