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
- Apps - How to add predefined stock background images
- Dataverse - How to work around the error "multiple levels of many-to-one relationship expansion aren't supported"
- SQL - How to return data from Stored Procedures to Power Apps
- Reading Dynamics 365 and Power Platform User Group successfully holds its Q1 2024 meetup
- Data - How to show the distinct rows from 2 data sources or collections
- Data - How to implement circular rotational date sorting
- Dataverse - The easiest way to modify Dataverse data outside of Dataverse and Power Apps
- Forms - When calling SubmitForm, how to debug the error "Network error when using Patch function"
- AI Builder - Where to find the AI Models in the Power Apps designer
- Text - How to truncate and add 3 dots / ellipsis to long label text
- Controls - How to build a control to enter measurements in inches with fractional units
- FormuIas - Is it possible to call a user-defined function recursively in Power Apps?
- Formulas - A beginners guide on how to create and call user-defined functions (UDFs)
- Text - How to display text and content upside down
- Dates - How to convert a month name (eg January, Feburary, March) to month number (eg, 1, 2, 3)
- SharePoint - Deleting the last record from a SharePoint list - how NOT to do this!
- The easiest way to caption images with AI in Power Apps
- Controls - Top 6 changes that are coming to Modern Controls in 2024
Blog Author
Tim Leung Author, software developer, Power Platform specialist |