Date format in Dropdown for Timesheet app including Time

(0) Share

Report

Posted on by vandam2

Using Aprils timesheet app - https://www.youtube.com/watch?v=qqEHiB6v_i4

Dropdown field is showing the date time on the picklist, but i only want the date

on her video, on her video it shows correct but on mine the dropdown includes the time (12:00 AM)

Dropdown Items: AddColumns(weeksList,"WeekEnd",DateAdd(Value,6,Days),"Week Display",Value&" to "&DateAdd(Value,6,Days))

app onstart has the following code

Concurrent(
Set(
currentUser,
User()
),
Set(
currentMonday,
DateAdd(
Today(),
-1 * (Weekday(
Today(),
Monday
) - 1),
Days
)
),
Set(
weeksList,
ForAll(
Sequence(
20,
Day(
DateAdd(
Today(),
-1 * (Weekday(
Today(),
Monday
) - 1),
Days
)
) - 28,
7
),
Date(
Year(Today()),
Month(Today()),
Value
)
)
)
);

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,714 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @vandam2 ,
Actually the second exact question I have responded to this week - try

AddColumns( weeksList, "WeekEnd", Text( DateAdd( Value, 6, Days ), "mmmm d, yyyy" ), "Week Display", Value & " to " & Text( DateAdd( Value, 6, Days ), "mmmm d, yyyy" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
vandam2 on at

Like
a
(0)

Report
Copy link

Link copied!

as usual, your solution worked like a charm 🙂

thanks again Warren
nehal2271 14 on at

Like
a
(0)

Report
Copy link

Link copied!
I have similar issue in Timesheet App whenever months changes the weekrange i.e Sat to Sun usually changes @WarrenBelz & @vandam2 . Could you please help? I am fairly new to understand it.

Here's the code snippet below. Note the work week usually starts from Sat to Sunday
Set( currentSunday, DateAdd( Today(), -1 * (Weekday(Today(), StartOfWeek.Sunday) - 1), TimeUnit.Days ) ); Concurrent( Set(currentUser, User()), Set( currentSunday, DateAdd( Today(), -1 * (Weekday( Today(), StartOfWeek.Sunday ) - 1), TimeUnit.Days ) ), Set( weeksList, ForAll( Sequence( 9, Day( DateAdd( Today(), -1 *(Weekday( Today(), StartOfWeek.Sunday ) -1) ) )-28, // Changed from 28 to 35 (i.e., 5 * 7) 7 ), Date( Year(Today()), Month(Today()), Value ) ) ) )