web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Datepicker

Power Apps

Answered

Datepicker

(1) Share

Report

Report

Posted on by GillesBruyneel

18

Hi,

i have a form with 2 datepickers to select beginning of a period and an ending.

But when i want to show those date on my other form, i get a bunch of numbers like this:

" 1643065200000 - 1674601200000 "

Does anyone know what to do? It should show something like:

"16/12/2000 - 01/01/2023"

My current formula is like this (dutch)

LookUp(Verval;'Naam + voornaam'=ThisItem.Result;Begin) & " - " & LookUp(Verval;'Naam + voornaam'=ThisItem.Result;Einde)

Begin & Einde are the names of the 2 datepickers wich are dd/mm/yyyy

edit: after some research i have found out it shows the date in EPOCH TIME.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

poweractivate 11,078 Most Valuable Professional on at

Like (1)

Report
@GillesBruyneel

When I test it with something like this below, I think it gives the values you might want:

1. Use this formula for the Text property of another Label
(assuming the value of interest is "1643065200000 - 1674601200000" in the Text property of a Label called Label1 in this example):
With ( {myItems:Split(Label1.Text," - ")} ,$"{Text(Value(First(myItems).Result),"[$-en-US]ddd, dd mmm yyyy hh:mm:ss")} - {Text(Value(Index(myItems,2).Result),"[$-en-US]ddd, dd mmm yyyy hh:mm:ss")}" )

See if it helps @GillesBruyneel

Was this reply helpful? Yes No
GillesBruyneel 18 on at

Like (0)

Report

Hi,
thank you for the reply. In my case the Label1 is called 'Periode'. When I enter your formula it does not work for me. It gives an error for 'period.text':

Was this reply helpful? Yes No
Verified answer

GillesBruyneel 18 on at

Like (0)

Report

SOLVED:
Text(LookUp(Verval;'Naam + voornaam'=ThisItem.Result;Begin); "[$-NL]dd/mm/yyyy") & " - " & Text(LookUp(Verval;'Naam + voornaam'=ThisItem.Result;Einde); "[$-NL]dd/mm/yyyy")

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

HI @GillesBruyneel,

Could you please Mark your reply as an answer to help more users?

Thanks for your cooperation.

Was this reply helpful? Yes No
GillesBruyneel 18 on at

Like (0)

Report

ok done

Was this reply helpful? Yes No

Join the conversation