Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=Concat(DayName(MonthEnd(now(1),ValueLoop(-12,1,1))),chr(10),????)
This expression returns dates sorted as text instead of date! How do I substitute ????
So the unwanted result:
28/02/2021
29/02/2020
30/04/2020
30/06/2020
30/09/2020
30/11/2020
31/01/2021
31/03/2020
31/03/2021
31/05/2020
31/07/2020
31/08/2020
31/10/2020
31/12/2020
I want this:
29/02/2020
31/03/2020
31/03/2021
30/04/2020
31/05/2020
30/06/2020
31/07/2020
31/08/2020
30/09/2020
31/10/2020
30/11/2020
31/12/2020
31/01/2021
28/02/2021
try this expression:
=Concat(DayName(MonthEnd(now(1),ValueLoop(-12,1,1))),chr(10),DayName(MonthEnd(now(1),ValueLoop(-12,1,1))))
try this expression:
=Concat(DayName(MonthEnd(now(1),ValueLoop(-12,1,1))),chr(10),DayName(MonthEnd(now(1),ValueLoop(-12,1,1))))
Thank you!
This is the final solution adopted (I need it in the listbox of input box in descending order till the previous end of month):
=Concat(DayName(MonthEnd(now(1),ValueLoop(-12,-1,1))),';',-DayName(MonthEnd(now(1),ValueLoop(-12,-1,1))))