Date problem

(0) Share

Report

Posted on by BP-06122300-0

Hello,

I have a problem in PowerApps. I have a button that should create or update a cell in a table based on an Input Text and a date chosen from three dropdowns (for year, month, and day). The button works and adds the text, but it always shows the next day’s date instead of the one I select. Does anyone know why this happens?

UpdateIf(
    User01;
    Text(DateValue(
        Text(DropdownYear.Selected.Value) & "-" & 
        Text(DropdownMonth.Selected.Value) & "-" & 
        Text(DropdownDay.Selected.Value)
    ); "[$-en-US]yyyy-mm-dd") = Text(Date; "[$-en-US]yyyy-mm-dd");
    {
        Activity: Input_Activity.Text
    }
)

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (0)

ronaldwalcott 3,862 Moderator on at

Like (0)

Report
Copy link

Link copied!
What date does your formula
Text(DateValue( Text(DropdownYear.Selected.Value) & "-" & Text(DropdownMonth.Selected.Value) & "-" & Text(DropdownDay.Selected.Value)
produce? Consider that you are converting dates to en-US but from your code you appear not to be in that locale. When you say that it is showing the next day's date are you considering your local date?

Was this reply helpful? Yes No
Suggested answer

pavanmanideep 551 Power Up Champ - 2025 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You may refer this https://learn.microsoft.com/en-us/troubleshoot/power-platform/power-apps/create-and-use-apps/troubleshoot-canvas-app-date-time-issues

Make sure you were doing date conversion to handle the dates properly.

Thank you.

Cheers,

PMDY

Was this reply helpful? Yes No