Announcements
I am using a DatePicker, and I would like to manipulate the selected information of this component, when they selected the data, I would like to add it + a time of interest to me. Example: They selected 10/8/2021. This date will be like 08/10/2021 00:00:00, I would like it to be 08/10/2021 23:00:00. It's possible?
Hi @Anonymous
{ 'Date reported': DatePicker1.SelectedDate + Time(Hour(Now()) , Minute(Now()), 0) }
We can hard time if needed
DataCardValue17.SelectedDate + Time(23 , 0, 0)
Hello, @StalinPonnusamy
Soma ( Filtro ('SALDO PRD ACUMULADO'; Dados> = Datainicio1.SelectedDate; Data <= Datafim1.SelectedDate + Time (20; 00; 00)); CP8)
Are you sure how it was entered into the role? must bring the result added according to the data generated and the time must be less than 23 hours for it to be added?
Note: The date is stored as UTC time in DB and it will display as the user's local time zone.
If you update the Date field like this
Then filter should be
Filter(IssueTracker,'Date reported' < DatePicker2.SelectedDate + Time(23 , 0, 0))
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 381 Super User 2026 Season 2
Mohsin Ali 340
WarrenBelz 187 Most Valuable Professional
