Every Monday in picklist

Like (0) Share

Report

Posted on 17 Oct 2022 15:57:56 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:

General Questions

I have the same question (0)

All responses (2)

Answers (1)

rbn_nue on 27 Jun 2023 at 04:01:32

Like (0)

Report

Re: Every Monday in picklist

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

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on 18 Oct 2022 at 03:29:04

Like (1)

Report
Re: Every Monday in picklist

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

Was this reply helpful? Yes No