web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Date format collection

Power Apps

Answered

Date format collection

(0) Share

Report

Report

Posted on by loopingmurdock

250

hey,

Dates again, am creating a collection for a course:

ClearCollect(ColEx, {Name:"Father", Surname: "Christmas", Age: 89, DateOfBirth: "10/25/1898"});

when i want to do a age control as follows:

DateDiff(Today(), DateValue(ThisItem.DateOfBirth))

I get [-45319]

What am i doing wrong please?

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (2)

Sort by

Verified answer

cha_cha 4,932 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @loopingmurdock

You got your values in the opposite place.
DateDiff( DateValue(ThisItem.DateOfBirth), Today())

Also if you want to get the years difference, use this:
DateDiff( DateValue(ThisItem.DateOfBirth), Today(), Years)
Verified answer

loopingmurdock 250 on at

Like
a
(0)

Report
Copy link

Link copied!

Some problem put no more -
loopingmurdock 250 on at

Like
a
(1)

Report
Copy link

Link copied!

Oh wait the year on is good sorry

Join the conversation