Answered

Date picker to set it monthly

(0) Share

Report

Posted on by foxngn84

Hi All,

May i know is it possible for PAD to be able to each time, it will chose a date that is a month before which is like choosing November 1st for the start date, and the end date with 31st of the month?

But i need to run this every month, is it doable?

date pick.png

Thanks

Categories:

Power Automate Desktop

All responses (4)

Answers (1)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

@foxngn84

yes, its possible.

For the end date, do you mean last day of current month or next month?
foxngn84 95 on at

Like
a
(0)

Report
Copy link

Link copied!

may i know how do i do that?
the end date is the last day of the previous month.

each month, i need to extract a full month data of the previous month.
Verified answer

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!
Copy paste the below into a blank Flow editor and run the flow

DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateOnly CurrentDateTime=> CurrentDateTime DateTime.Add DateTime: CurrentDateTime TimeToAdd: -1 TimeUnit: DateTime.TimeUnit.Months ResultedDate=> ResultedDate Text.ConvertDateTimeToText.FromCustomDateTime DateTime: ResultedDate CustomFormat: $'''01/MM/yyyy''' Result=> StartDate DateTime.Add DateTime: StartDate TimeToAdd: 1 TimeUnit: DateTime.TimeUnit.Months ResultedDate=> ResultedDate DateTime.Add DateTime: ResultedDate TimeToAdd: -1 TimeUnit: DateTime.TimeUnit.Days ResultedDate=> ResultedDate Text.ConvertDateTimeToText.FromCustomDateTime DateTime: ResultedDate CustomFormat: $'''dd/MM/yyyy''' Result=> EndDate Display.ShowMessageDialog.ShowMessage Message: $'''The start date is: %StartDate% The end date is: %EndDate%''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed2

Once you get the dates write them to the datepicker textboxes.
foxngn84 95 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @VJR i able to get it runs with your guide here. Appreciated !