Need help Please

(0) Share

Report

Posted on by JC-04111302-0

Hi Community

I am still struggling with a date to be inserted in a database. How can I refresh the below before I submit the form.?

Issue:

Time now is 9:32 am. If I update the record, Date/Time is properly inserted in the Sql server.

But in a given scenario, where I leave the application open and come back in 1 hr, when it is now 10:32 am, the variables are still 9:32 on the screen ( normal) and the record is being updated with that time which is wrong.

I want a refresh of the Date/Time fields below when I press on the Update Button, just before the SubmitForm( Form1) is executed. Please assist me with the codes to be inserted prior. Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

JC-04111302-0 18 on at

Like (0)

Report
Copy link

Link copied!

Hi Community

I am still struggling with a date to be inserted in a database. How can I refresh the below before I submit the form.?

Issue:

Time now is 9:32 am. If I update the record, Date/Time is properly inserted in the Sql server.

But in a given scenario, where I leave the application open and come back in 1 hr, when it is now 10:32 am, the variables are still 9:32 on the screen ( normal) and the record is being updated with that time which is wrong.

I want a refresh of the Date/Time fields below when I press on the Update Button, just before the SubmitForm( Form1) is executed. Please assist me with the codes to be inserted prior. Thanks.

Was this reply helpful? Yes No
JC-04111302-0 18 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
WarrenBelz 154,536 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Three posts in five minutes is only going to take this off the "no responses" list and less people will look at it. Try sending Now() in your Patch to your data source - it will send the current time. Otherwise reset the hour and minute drop-downs before you save.

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