Category: Datetime
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
- 2023 Release Wave 1 - The 5 best new features planned for Power Apps 2023
- Power App Makers can now create up to 3 Developer Environments per user!
- Save the Date - Powerful Devs Conference February 15 2023
- Dataverse - How to create Entity Relationship diagrams
- Data - How to group data in a gallery and calculate sums
- Dataverse - How you can more quickly bulk update data using the SQL language
- Dataverse - How to fix the bug in the 'Business Rules' editor that prevents numeric values from saving
- Training - List of Virtual Training Day Events in January and February 2023
- Barcodes - How to scan barcodes - a summary of the 3 available barcode scanning controls
- Formula - How to calculate compound interest
- Data - What to do when the data panel is missing in designer
- Editor - How to save and overwrite an existing app in Power Apps
- PCF - How to get the IP address of the client
- Demo app - How to save data like a pro - Southcoast Summit Presentation
- Error - How to fix "Sign-in to continue" loop problem in the model driven app designer
- Colors - How to convert Power App colors to hex
- Templates - Discover UI inspiration ideas through community Power App templates on Figma
- Dates - How to calculate UK tax weeks
Blog Author
![]() |
Tim Leung Author, software developer, Power Platform specialist |