Power Apps: DateDiff Function
Returns the difference between two dates in days, hours, months, or other units.
Welcome to my Microsoft hub, the starting point for everything I write about the Microsoft ecosystem. Here you'll find tutorials, references, and practical tips across the Microsoft 365 and Power Platform family, grouped into focused areas so you can jump straight to what you need. If you build automations, start with Power Platform, where I cover Power Automate, Power Apps, and Power BI. For everyday productivity, browse Excel for formulas and data tricks, Microsoft Teams for collaboration, and Microsoft Planner and Microsoft To Do for keeping tasks organized. Working with data and files? OneDrive, Microsoft Lists, and Microsoft Forms each have their own space with hands-on guides. Developers and admins can dig into Microsoft Graph and PowerShell for scripting across SharePoint, Azure, and Microsoft 365. I also cover Microsoft 365 Copilot, Microsoft Outlook, OneNote, and Shifts, showing how these products fit together in real workflows.
Returns the difference between two dates in days, hours, months, or other units.
Joins strings, numbers, and dates into a single value. Up to 30 items.
Returns today's date with time set to midnight. Volatile.
Adds seconds, minutes, hours, or days to a date in one call.
Converts a date into any format using specifiers or custom patterns like 'ddd MM yyyy'.
Returns the remainder of a division.