Answered

Need help Please

(0) Share

Report

Posted on by JC-04111302-0

I have a column "Last Updated on" in my Sql Server Database, as Date Time. I am trying to update it on my Power App, which is working well for the other fields ( Text, Number, ...).

When I add the "Last Updated On" in my application. it displays as below, in 3 segments:

How can I get it to only One data field with the Date and Time concatenated using the Now() function. Thanks to advise me. I have been stuck on this for some time despite looking for videos.

Categories:

General Questions

I have the same question (0)

All responses (3)

Answers (1)

Meekou 200 Moderator on at

Like (0)

Report
Need help Please

For build date time based on multiple input, you could try DateTime function to combine them.

Here is a demo

DateTime( Year(datePicker.SelectedDate), Month(datePicker.SelectedDate), Day(datePicker.SelectedDate), hourpicker.Selected.Value, minutePicker.Selected.Value, 0 )

Regards,
Meekou
Personal Support

Was this reply helpful? Yes No
ronaldwalcott 3,827 Super User 2025 Season 2 on at

Like (0)

Report

Need help Please

If you are not entering a datetime you could use a label to show Now()

Was this reply helpful? Yes No
Verified answer

timl 35,805 Super User 2025 Season 2 on at

Like (0)

Report
Need help Please

Hi JC-04111302-0

From what I understand, you want to replace the datepicker, hour dropdown, and minute dropdown with a single text input control that defaults to the current date and time.

To do this, you would delete these 3 controls and insert a text input control within the existing data card (let's call the new control txtLastUpdatedOn). You would set the Default property of this to Now().

You would then change the Update property of the data card that contains txtLastUpdatedOn to the following:

DateTimeValue(txtLastUpdatedOn.Text)

Was this reply helpful? Yes No