Announcements
Hello,
Is there any way to make our input text auto change format into date format?For example:Input text: 190301 ----->> Auto change into date format: 01/03/2019Regards.
Yes, but you would have to be consistent in how you write it. you cant just do a random string like 190215 and expect it to know that means d/m/y...
DateValue(Text(textinput.text, "m/d/yyyy"))
Hi @cds Thank for your reply.Is it works if i use a text box control?
you will have to set it as a global or contextual variable.. OnChange = Set(ThisDate, DateValue(Text(TextInput.Text, "mm/dd/yyyy")))
Hi @cds I try your formula both in variable and direct to the text box, but i dont get the result as i hoped:you see, the result is 1/1/1903 when i entered the text value as 190301.
what i needed is 01/03/2019 as date format result.I'm hoping to get this:Text box value: 190301Date format result: 01/03/2019 (dd/mm/yyyy) or 03/01/2019 (mm/dd/yyyy)Is this achieveable with powerapps?
It is possible but you are going to have to do some serious string manipulation
can you help?
OK so here is your label: VarDay&"/"&VarMonth&"/"&VarYearOn your TextInput.OnChange put this:UpdateContext({VarYear: "20"& Left(TextInput.Text, 2), VarMonth: Mid(TextInput.Text, 3,2), VarDay: Right(TextInput.Text, 2)})This solution wont work for 1900's or 2100's
@cds This is wonderful!I will try it as soon as i arrived at the HQ.Thanks in advance!Ps.I may have follow up questions for i am a noob in powerapps programming language.
For sure! I appreciate the kudos and if it does work, please accept my solution! 😃
@cds Where should i put this:VarDay&"/"&VarMonth&"/"&VarYear?
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 762
11manish 640
Valantis 548