Power Platform Community Forum Thread Details

Please follow the below approach:

Set the Date String: Create string variable Strdate to the value 4mar2024, representing the date "24th March 2024".
Convert Text to DateTime: The code then converts the text representation of the date stored in Strdate to a DateTime format using the this function. The converted DateTime value is stored in the variable ConvertedDateTime.
Convert DateTime to Custom Text Format: Next, the code converts the DateTime value stored in ConvertedDateTime to a custom text format using this function. The custom format specified is dd, which represents the day of the month. The resulting formatted date text is stored in the variable FormattedDateTime.
Convert Text to Number: The code then converts the text representation of the formatted date stored in FormattedDateTime to a number using this function. The resulting number is stored in the variable TextAsNumber.
Calculate First Date of Previous Month: After converting the text to a number, the code subtracts the number of days represented by TextAsNumber minus one from the original date (ConvertedDateTime) using the DateTime.Add function. This calculates the first date of the previous month and stores it in the variable Firstdate.
Calculate Last Date of Current Month: The code then adds one month to the first date of the previous month (Firstdate) using the DateTime.Add function, resulting in the last date of the current month, stored in the variable LastDate.
Calculate Last Day of Current Month: The code subtracts one day from the last date of the current month (LastDate) using the DateTime.Add function to get the last day of the current month, stored in the variable LastDayInMonth.
Calculate Final Date: Finally, the code subtracts 60 days from the last date of the current month (LastDate) using the DateTime.Add function, resulting in the final date, stored in the variable FinalDate.

Code:

SET Strdate TO $'''24mar2024'''
Text.ConvertTextToDateTime.ToDateTime Text: Strdate DateTime=> ConvertedDateTime
Text.ConvertDateTimeToText.FromCustomDateTime DateTime: ConvertedDateTime CustomFormat: $'''dd''' Result=> FormattedDateTime
Text.ToNumber Text: FormattedDateTime Number=> TextAsNumber
DateTime.Add DateTime: ConvertedDateTime TimeToAdd: $'''-%TextAsNumber - 1%''' TimeUnit: DateTime.TimeUnit.Days ResultedDate=> Firstdate
DateTime.Add DateTime: Firstdate TimeToAdd: 1 TimeUnit: DateTime.TimeUnit.Months ResultedDate=> LastDate
DateTime.Add DateTime: LastDate TimeToAdd: -1 TimeUnit: DateTime.TimeUnit.Days ResultedDate=> LastDayInMonth
DateTime.Add DateTime: LastDate TimeToAdd: -60 TimeUnit: DateTime.TimeUnit.Days ResultedDate=> FinalDate
Display.ShowMessageDialog.ShowMessage Message: $'''New Date : %FinalDate%''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed

How to copy/paste the above code into your power automate desktop?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀