Platform Banner

Power FX - Date and Time Function Tutorial

Unlock the secrets of time management in your apps with the "date and time function" video! Discover essential Power FX functions like NOW, TODAY, and DATEADD through practical examples. Learn to automate date calculations and enhance user experience in just one tutorial. Don't miss this chance to elevate your low-code skills!

02:53
601 views

Available in Microsoft365

00:00:02

essential for manipulating temporal information in your applications.

00:00:06

They allow you to display,

00:00:07

calculate,

00:00:08

and compare dates and times,

00:00:10

which is crucial in many professional contexts.

00:00:13

In this tutorial,

00:00:14

we will explore several of these functions using concrete examples.

00:00:19

The now function returns the current date and time.

00:00:22

It is useful for time stamping events or tracking activities in real time.

00:00:28

Let's continue with the today function,

00:00:30

which returns the current date without the time.

00:00:33

It is ideal for operations where only the date is relevant.

00:00:38

In a daily activity report application,

00:00:40

we want to compare the report date entered by the user with the current date.

00:00:45

If the user enters the date in a text box,

00:00:47

you can check if the report concerns the current day.

00:00:51

Note that using date value is crucial as it transforms

00:00:54

the date entered by the user into a date format,

00:00:57

given that an input field uses text format by default.

00:01:01

Here the application informs the user whether the

00:01:04

report corresponds to the current date or not.

00:01:07

After obtaining the current date and time,

00:01:09

it is often necessary to manipulate these dates.

00:01:13

The date add function allows you to add or subtract a certain number of units,

00:01:17

days,

00:01:17

months,

00:01:17

years to a specific date.

00:01:19

To calculate the due date of a task based on the number of days allocated,

00:01:23

you can use date add.

00:01:25

If the user enters the number of allocated days in a text box,

00:01:29

you calculate the due date as follows.

00:01:32

As previously mentioned,

00:01:33

using the value function converts the text box format to numeric format,

00:01:38

as by default,

00:01:39

it is in text format.

00:01:40

Thus,

00:01:41

the application automatically calculates the deadline by adding the

00:01:44

specified number of days to the current date.

00:01:48

Let's continue with the date diff function,

00:01:50

which calculates the difference between two dates in specified units,

00:01:54

days,

00:01:55

months,

00:01:56

years.

00:01:57

This function is very useful for measuring durations or deadlines.

00:02:01

In a human resources application,

00:02:04

to calculate an employee's seniority,

00:02:06

you ask them to enter their hiring date in a text box.

00:02:09

You can then calculate their seniority in years using this formula.

00:02:14

This determines the number of years elapsed from the hiring date to today.

00:02:20

There are many other date functions,

00:02:22

but those we have covered in this video are among the most used.

00:02:27

By mastering Power FX's date and time functions,

00:02:30

you can enrich your Power App's

00:02:31

applications by effectively managing temporal information.

00:02:35

These functions allow you to automate date calculations,

00:02:38

validate user inputs,

00:02:40

and customize the user experience based on the temporal context.

00:02:44

Integrating these tools into your projects will help

00:02:46

you meet the specific needs of your organization

00:02:49

and improve the efficiency of your applications.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

490 Views

Video Training Microsoft Power FX : Master Power FX to optimize your applications in a low-code environment

Master Power FX to optimize your applications with powerful and flexible functions in a low-code environment.

ALL COURSES