Category: Datetime
Datetime - Preventing user manipulation of the current time - how to retrieve a server date time value
If you want to retrieve the current date and time in a way that can't be manipulated by the user changing the device time, here's a technique you can use.
Dates - How to display minutes as hours/minutes, and days/hours/minutes
If you need to convert an input value in minutes into hours and minutes, this post describes the formula to carry out this task.
Formula - How to round times to the nearest x minutes
When working with dates and times, a common requirement is to round times up or down to the nearest X minutes. This post describes the formula to carry out this task.
Dates - How to convert dates to Islamic Hijri format
Where we need to convert Gregorian date to Islamic Hijri dates, a quick and simple way to carry out this task is to import a static table of lookup values. This post walks through how to apply this technique.
Data - How to filter records by a specific date, today's date, or range of dates
A common requirement to filter a list of records by date. This post describes the formula to carry out three common tasks - how to filter records by a specific date, today's date, or a range of dates. We also cover the formula to return all dates, if the user does not select a date.
Formulas - how to return all days or working days in a month
They can often be the requirement to return all working days in a month, particularly in cases where we develop timesheet or reporting type apps. This post describes the formula to carry out this task.
Dataverse - How to calculate durations with calculated columns
We can use calculated columns to calculate the difference between two date/time values. The available functions that apply to date fields work only between columns of the same behaviour type. This can cause problems, mostly in cases where we need to calculate an elapsed duration with the help of the Now() function. This post examines this issue, and offers a quick overview on how to define a calculated column.
Recent Posts
- Dynamics 365 and Power Platform User Group Q4 2024 meetup
- Bug - What to do when setting a variable to Form.LastSubmit doesn't work
- Datetime - Preventing user manipulation of the current time - how to retrieve a server date time value
- Controls - How to set the date picker icon size - Workaround
- Low Code No Code Microsoft Power Platform Conference 2024
- Apps - The new easier way to open .msapp files 2024
- Charts - A simple way to create better graphs and charts
- Controls - How to workaround the bug when setting Radio Button fill color dynamically
- Data - How to find the common rows from 3 or more collections
- Editable Gallery - How to set a control value dynamically when a user changes the value of another control
- Formula - How to rank times including joint times and ties
- SQL Server - Grandfathered licensing model to end on October 1, 2024
- Reading Dynamics 365 and Power Platform User Group successfully holds its Q3 2024 meetup
- Bug - How to fix problem with the advanced section of the properties pane appearing blank
- What happened at the Power Apps track at the Low Code Power Summit 2024?
- Designer - The upcoming ability to copy and paste source code from the designer will be a fantastic enhancement
- Error - Diagnosing the error "Network error when using the Patch function" when saving data with a form
- Apps - How to add predefined stock background images
Blog Author
|
Tim Leung Author, software developer, Power Platform specialist |