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)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

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,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,846 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 155,450 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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