Answered

PowerApp - Converting Date serial number to short date format in textbox

(0) Share

Report

Posted on by Ralph_C

Hi, i have a sharepoint list that has date serial numbers. Need help how to convert the number to a short date format in a text box

This is what i have at the moment

Text(LookUp('Listname',Column_name =Item_No, Date),"mm/ddyyyy")

Thank you for the help.

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Text( DateTimeValue( LookUp('Listname',Column_name =Item_No).Date, "mm/dd/yyyy" )

Try that

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community
Ralph_C 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the quick reply. unfortunately, no text was returned.
here's my actual code
Text( DateTimeValue( LookUp('OTC CoE - LPA Schedule Slots Tracker',Slot_Number ="Slot 1").Date, "mm/dd/yyyy" ))
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Try just this:

Text( DateTimeValue( LookUp('OTC CoE - LPA Schedule Slots Tracker',Slot_Number ="Slot 1").Date))

Plus, make sure that your lookup is not empty

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community
Ralph_C 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Nogueira1306,
Appreciate you working with me on this.
I tried the code it returned something but was not the correct date. let me add some context
- The user will need to select a slot using a button, then once selected it should retrieve the value from the 'Date' column from SP
- using 'Slot 1' as lookup ref, the value 44522 should be returned (for Nov 22, 2021)
- wanted to convert the 44522 to 11/22/2021

Thanks
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

44522 is a date??

I am not understanding nothing..

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community
Ralph_C 17 on at

Like
a
(0)

Report
Copy link

Link copied!

i was hoping that would be the case. To convert the Date serial number used in Excel to a short date.
(also, sorry 44522 is Nov 22 not Nov 1)

https://support.microsoft.com/en-us/office/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252
refer to the remarks section.
Verified answer

timl 37,306 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Ralph_C

This should hopefully work for you:

Text( DateAdd(Date(1900,1,1), LookUp('OTC CoE - LPA Schedule Slots Tracker',Slot_Number ="Slot 1").Date -2 , Days ), "mm/dd/yyyy" )
Ralph_C 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Amazing! that worked so well. Thank you so much.