Category: Dates
Dates - How to calculate UK tax weeks
If you need to convert dates to UK tax weeks or generate a list of the start and end dates for tax weeks in a year, this post describes some formula that you can use.
Dates - How to convert dates from MM DD YYYY to DD MM YYYY and vice versa
This post describes how to convert dates in the US format "mm dd yyyy", to "dd mm yyyy" format.
Dates - How to detect overlapping times / scheduling conflicts
When building apps, there can often be the need to detect overlapping times. This post describes the methodology and formula to carry out this task.
Dates - How to display or convert Excel date serial numbers
Microsoft Excel stores dates as serial numbers. This post describes this behaviour and shows the formula to convert and display Excel date serial numbers in Power Apps.
Dates - How to get the start date from week number
When working with dates, there may be the requirement to derrive the start date of a week based on a week number. This post describes the formula to carry out this task.
Dates - How to check if a year is a leap year
Working with dates, it can sometimes be necessary to work out whether a given year is a leap year. This post describes a technique we can use to carry out this task.
Dates - How to get the week number for a given date
A common requirement is to calculate week numbers. Up till now, this task could be difficult to accomplish but now, Power Apps introduces the WeekNum and ISOWeekNum functions to help simplify this task. This post describes how these two new functions work.
Dates - How to get the nth weekday for a month
When building apps, it can be very useful to determine the nth workday in a month. For example, what's the 2nd Tuesday in a month, what's the 3rd Wednesday for a month, what's the first Monday (etc)? This post describes the formula to carry out this task.
Dates - How to get the last weekday for a month
When building apps, it can be very useful to determine the last workday in a month. For example, what's the last Thursday in a month? This post describes the formula to carry out this task.
Dates - How to get a numbered list of days or months, starting from a specified day or month
For date or scheduling diary type apps, it can be very useful to retrieve a list of days or months that begin on specific day or month. This post describes some formulas that we can use.
Controls - How to display dates in a combo box
The combo box control does not support the display of date values. This post examines this behaviour and describes a method to overcome this issue.
Search - How to filter records by month and year using a delegable expression
A common question I often see is - how do I filter a table or SharePoint list by month and year? This post describes how to carry out this task using formula that is delegable.
Recent Posts
- What AI features are coming to Power Apps 2023?
- Formula Editor - Why should you enable the new formula bar? Old vs New compared.
- Text - How to split input strings by carriage return followed by the colon character
- Certifications - How to renew Miorcosoft certifications for 12 months
- Formula - How to display a count of grouped non-blank and blank rows
- What's new in the updated Maker Portal navigation menu? A comparison of Old vs New
- User Group - UK Reading Dynamics365 and Power Platform User Group Meetup Dates 2023
- Controls - How to set height of nested galleries dynmically
- 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
- First UK Reading Dynamics 365 & Power Platform User Group meeting
- 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
Blog Author
![]() |
Tim Leung Author, software developer, Power Platform specialist |