Date Picker

(0) Share

Report

Posted on by akbarmahfuzalam

709

Hello,

I have an app where in I want the user to give input from Date Picker but the range they select give me either 15-date of the month (15-Oct-2020) or last date of the Month (31-Oct-2020)

How do I achieve that.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

ricardox180 190 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi! @akbarmahfuzalam. Maybe you should use the Today () function, put it in the "DefaultDate" property of the DatePicker
Vijay Tailor 2,961 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @akbarmahfuzalam ,

See the Solution for your requirement.
Hope this will help you to achieve your requirement.
Code below -
If(Value(Text(DatePicker5.SelectedDate,"[$-en-US]d"))>=1 && Value(Text(DatePicker5.SelectedDate,"[$-en-US]d"))<=15,DateValue(Text(Text(DatePicker5.SelectedDate,"[$-en-US]mm")&"/"&"15/"&Text(DatePicker5.SelectedDate,"[$-en-US]yyyy"))),If(Value(Text(DatePicker5.SelectedDate,"[$-en-US]d"))>=16 && Value(Text(DatePicker5.SelectedDate,"[$-en-US]d"))<=31,DateAdd( DateAdd( Date(Year(DatePicker5.SelectedDate), Month(DatePicker5.SelectedDate), 1), 1, Months), -1, Days)))

Thanks,
Vijay
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay
akbarmahfuzalam 709 on at

Like
a
(0)

Report
Copy link

Link copied!

@VijayTailor
Hi Vijay,

How do use the same thing on the date picker itself. You have shown me on Text value change. But here I want the value to be shown on the Date Picker itself, irrespective of what the user selects the Date.