Unanswered

Date Picker

(0) Share

Report

Posted on by Community Power Pla...

I'm using a DatePicker, and I would like to manipulate the selected information of this component, when they select the date, I would like to add it + a time of interest to me. Example: They selected 10/8/2021. This date will be like 10/08/2021 00:00:00, I would like it to be 10/08/2021 99:99:99. It's possible?

Categories:

Power Apps portals

I have the same question (0)

All responses (5)

Answers (0)

OOlashyn 3,496 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,

You cannot add time portion like that as it is stored as a DateTime value in the system and time part cannot go beyond 24 hours. You can find more about DateTime here - https://docs.microsoft.com/en-us/dotnet/api/system.datetime?view=net-5.0.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Yes but it doesn't have to be 99:99:99 it can be 24:00:00 was an example

Was this reply helpful? Yes No
OOlashyn 3,496 Most Valuable Professional on at

Like (0)

Report
You can use javascript or jquery to set the value of the field as you like. You can find more about datetime field in my blog post - https://www.dancingwithcrm.com/date-fields-on-powerappsportals/ and in official docs for the widget https://getdatepicker.com/4/Options/ . To set the date with code you can use next code:

$('YOUR_FIELD_ID').next().data("DateTimePicker").date(new Date())

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I can use this code in this function
Sum (
Filter('SALDO PRD ACUMULADO';Data>= Datainicio1.SelectedDate;Data<= Datafim1.SelectedDate);
If(comboModelo.Selected.Modelo<>"All";Modelo=comboModelo.Selected.Modelo;CP8))

Was this reply helpful? Yes No
OOlashyn 3,496 Most Valuable Professional on at

Like (0)

Report

Based on the function in your reply I assume you are talking about DatePicket in Canvas Apps not in Power Apps Portals. This is a forum for Portals questions. If you want to get an answer about Canvas Apps please post it in the forum here - https://powerusers.microsoft.com/t5/Building-Power-Apps/bd-p/PowerAppsForum1

Was this reply helpful? Yes No