Announcements
I am creating an app where I have two User text fields: MONTH entered as 'mm' & YEAR as 'yyyy'. I have a label whose default = "28/"&txtMonth.Text&"/"&txtYear.Text e.g. MONTH = 05, YEAR = 2021, LblPlannedDate = 28/05/2021 This works exactly as I wanted it . When I put the default of the PlannedDate date picker field to = lblPlannedDate.Text the result is 05/04/2023 What do I need to get the Datepicker to pick up the correct date as per the label?
Try entering the month format as 'MM'. The lowercase 'mm' is used for minutes in Date time formats.
Sorry I meant that the MONTH is just a text box where they enter the information as 01, 02, 03 etc., it is not a date format. So basically it is a label which pulls text boxes together. Is there a way to make the text field for Month a recognised date form of Month!?
Use the datetimevalue() function in default date of the datepicker. Something like this, with your regional setting.
DateTimeValue(Concatenate(Month.Text,"/28/",Year.Text),"en-US")
Thank you so much, this is exactly what I wanted. 🌟
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
