Unanswered

DatePicker showing random date

(0) Share

Report

Posted on by zuzuzuzu

Hi All. I have a dropdown with Completed and Not Completed. And I have a datepicker to display todays date if Completed is selected. This is the formula I am using for default date but it shows 11/2/2025 in the datepicker box when Completed is selected.

Any ideas?

If(
ComboBox1.Selected.Value = "Not Completed",
Blank(),
If(
IsBlank(ThisItem.SignOffDate),
Text(
Today(),
"dd-mm-yyyy"
),
ThisItem.SignOffDate
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Yogesh Murugan 443 Moderator on at

Like (0)

Report

Try this code
If(
ComboBox1.Selected.Value = "Not Completed",
Today(),
If(
IsBlank(ThisItem.SignOffDate),
Today(),
ThisItem.SignOffDate
)
)

Was this reply helpful? Yes No
Verified answer

SpongYe 5,603 Super User 2025 Season 2 on at

Like (1)

Report
Hi @zuzuzuzu

Try this formula:

If( ComboBox1.Selected.Value = "Not Completed", Blank(), If( IsBlank(ThisItem.SignOffDate), Today(), // Removed Text() here ThisItem.SignOffDate ) )

Please add any format in the format property in the DatePicker control:

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
zuzuzuzu 7 on at

Like (0)

Report

Hi @SpongYe ,

That worked but when I go to populate some data in a text field, it shows as a US date.

'Class Status Data':Concat(ForAll(colUserClass,CertName&", "&ClassName&":"&ClassStatus&", Sign Off By:"&SignOffBy&", Sign Off Date:"&SignOffDate&"; "),Value)&varClassStatusData,
Team:{Value:ComboBox2.Selected.Value}

The &SignOffDate& shows as US date. Is there any addition to the code here that it will be saved as EU date?

Was this reply helpful? Yes No