Datepicker

(1) Share

Report

Posted on by GillesBruyneel

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 (5)

Answers (1)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@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
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

ok done

Was this reply helpful? Yes No