Handy PowerApps Date Functions

I”m posting this as a reminder for myself and hopefully others will also benefit from it.

Here are some handy PowerApps functions to help with Date Calculations especially calculating first and last day of the month:

Get the current Date: Today()
Get the current Month: Month(Today())
Get the current Year: Year(Today())

Formatting a date object in PowerApps: Text(Today(),"[$-en-US]dd-mmm yyyy")

Get the first day of the current Month: Date(Year(Today()),Month(Today()),1)
Get the last day of the current Month: DateAdd(Date(Year(Today()),Month(Today())+1,1),-1,Days)

Leave Comment

Your email address will not be published. Required fields are marked *