Restrict date field to month start days only

(1) Share

Report

Posted on by SC-08081331-0

I want to restrict user to select only starting day of the month when setting it on model driven app. For example, if the user is trying to select Aug 8th, 2024, it should not let the user select it and throw an error message, unless the user selects 1st Aug, 2024.

I do not want to use canvas app for this. Trying to solve this using business rules. Any help is appreciated, thank you in advance.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

HI

While you can do things with JavaScript (assuming you mean on a Form), have you thought about creating either a Choice, or a LookUp table.

The look up table would only have 12 dates in it, the 1st of each month, then only let them select from that field on your form, then there is no way for them to select anything but the 1st of a month.

Was this reply helpful? Yes No
Suggested answer

lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

a) have a year and month selector rather than a date selector

b) accept whatever the user enters and then quietly replace the day value with 1 in the backend.

Was this reply helpful? Yes No
Suggested answer

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

You can use below JAVASCRIPT to achieve the same

function validateDate(executionContext) {
var formContext = executionContext.getFormContext();

var dateField = formContext.getAttribute("your_date_field_name");

if (dateField) {

var selectedDate = dateField.getValue();

if (selectedDate) {

var day = selectedDate.getDate();

if (day !== 1) {

// Set error message

dateField.setValue(null); // Optionally clear the field

formContext.getControl("your_date_field_name").setNotification("Please select the 1st day of the month only.", "error");

} else {

// Clear error message if date is valid

formContext.getControl("your_date_field_name").clearNotification("error");

}

}

}

}

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi SC-08081331-0

Try this OnChange of your Date Picker
UpdateContext( { varFirst: Date( Year(Self.SelectedDate), Month(Self.SelectedDate), 1 ) } ); Reset(Self)

then the DefaultDate
If( Value(varFirst) > 1, varFirst )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No