Answered

Every Monday in picklist

(0) Share

Report

Posted on by CU17121854-0

Hi,

I used this code to get every Monday of the week in a picking list. It was working very well.

ClearCollect(weeksList,
 ForAll(Sequence(52,-26,1) As DD,
 DateAdd(DateAdd(Today(),-Weekday(Today(),Monday)+1),7 * DD.Value ,Days)
 )
);

I don't know why, it now shows time with the date. Can you help me to get ride of this time ? Since this, my gallery isn't working. Is there a way to get around this ?

Thanks

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @jlarouche21 ,

Maybe you can try the following formula:

ClearCollect(weeksList, ForAll(Sequence(52,-26,1) As DD, Text(DateAdd(DateAdd(Today(),-Weekday(Today(),Monday)+1),7 * DD.Value ,Days),DateTimeFormat.ShortDate) ) );

Best Regards,

Charlie Choi
rbn_nue on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yujincui-msft

This helped me. But how can I modify it to get values of current financial year (eg: 2022 April 1 to 2023 March 31)
Could you please help?

Thanks,
Robin