Calculate Date of Birth from ID number column in a SharePoint List

(0) Share

Report

Posted on by Laela

Hi there,

I was wondering if it would be possible to calculate Date of Birth from an ID number column in a SharePoint List?

The ID number column has the first 6 digits as the person's date of birth i.e. if the ID number is "920320 0003 084", the date of birth would be 20/03/1992 or 20 March, 1992.

Kind regards,

Laela.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Insert a textbox and put this formula:
Text(Left(Textbox1.Text,6),"dd-mmm-yyyy")

Where Textbox1 is where the ID column is entered

Was this reply helpful? Yes No
Laela 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @eka24 ,

Thank you for your reply.

I added the formula to the date field that I had for Date of Birth and this is what it gave me:

This is the formula I had for the Date of Birth text input:
Text(Left(DataCardValue41_1.Text,6),"[$-en-GB]dd-mmm-yyyy") where "DataCardValue41_1" was the RSA ID Number text input.

It doesn't seem to be displaying correctly - please let me know how I can fix this?
I am using a date field for date of birth because I need to use it to calculate age in another SharePoint calculated column.

Kind regards,
Laela.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Laela ,

Do you want to get the birth date from entering number?

Could you tell me where do you get the year 1992 in your example? from "92"?

If so, do you mean that you set the year as "19xx" by default?

If so, I suggest you set the DatePicker's DefaultDate:

Text(Concatenate("19",Left(TextInput4.Text,6)),"[$-en-US]yyyy/mm/dd")

On your side, you may need this:

Text(Concatenate("19",Left(DataCardValue41_1.Text,6)),"[$-en-US]yyyy/mm/dd")

//then you will get the birth date in the format of the datepicker's default format.

Since you want this format: "dd/mm/yyyy", so please set the datepicker's Format:

"dd/mm/yyyy"

Then you will get the birth date in the format as you want.

Best regards,

Was this reply helpful? Yes No
Laela 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yutliu-msft,

Thank you so much, I entered this formula and it works perfectly!

Text(Concatenate("19",Left(DataCardValue41_1.Text,6)),"[$-en-US]yyyy/mm/dd")

This is my result:

Thank you so much for your help!

Kind regards,
Laela.

Was this reply helpful? Yes No
Horlickdebo5350 2 on at

Like
a
(0)

Report
Copy link

Link copied!

14531219

Was this reply helpful? Yes No