what is the synatx for this month and next month?? Thanks

(0) Share

Report

Posted on by bbsin

1,994

May I know what is the syntax for this month and next month

is it 15 and +15?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bbsin ,
How and where do you want to display of this month and the next month?
Do you want to display the date of the first day and the last day in the current month and the next month?
If yes, you can try below formula.
To get the date of the first day of this month, you can use this formula:

Date(Year(Now()), Month(Now()), 1)

To get the date of the last day of this month, you can use this formula:

DateAdd( DateAdd( Date(Year(Now()),Month(Now()),1), 1, Months ), -1, Days )

To get the date of the first day of next month, you can use this formula:

DateAdd( Date(Year(Now()),Month(Now()),1), 1, Months )

To get the date of the last day of next month, you can use this formula:

DateAdd( DateAdd( Date( Year(Now()), Month(Now()), 1 ), 2, Months ), -1, Days )

Using above formula where required to meet your actual requirement.

Best regards,

Allen

Was this reply helpful? Yes No
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @v-albai-msft

Can I check with u the number for next month is not right, can you advise as it's show as 9/9/ right? I am using today as reference. thanks

{
DisplayName: "Next Month",
StartDate: DateAdd(
Date(Year(Now()),Month(Now()),1),
1,
Months
),
EndDate: DateAdd(
Today(),
-60 - Weekday(
Today(),
StartOfWeek.Monday
) + 60,
Days
)
}
)

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bbsin ,

The code in Text and the code inside your screenshot are different.

Anyway, from your information, I am not sure which date do you want to display.

If today is 12/07/2021, do you want to display 12/08/2021?

If yes, just try this(edit below code to show any date based on Today()):

Date(Year(Today()), Month(Today())+1, Day(Today()))

Best regards,

Allen

Was this reply helpful? Yes No
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Allen,

Check with you there is error the dropdown not showing.. can you kindly advise,
ClearCollect(
colTimeFilter,
{
DisplayName: "This Week",
StartDate: DateAdd(
Today(),
1 - Weekday(
Today(),
StartOfWeek.Monday
),
Days
),
EndDate: DateAdd(
Today(),
1 - Weekday(
Today(),
StartOfWeek.Monday
) + 6,
Days
)
},{
DisplayName: "This Month",
StartDate: Date(Year(Now()), Month(Now()), 1),

),
EndDate:
DateAdd(
DateAdd(
Date(Year(Now()),Month(Now()),1),
1,
Months
),
-1,
Days)
},
{
DisplayName: "Previous Month",
StartDate: DateAdd(
Today(),
-30 - Weekday(
Today(),
StartOfWeek.Monday
),
Days
),
EndDate: DateAdd(
Today(),
-30 - Weekday(
Today(),
StartOfWeek.Monday
) + 30,
Days
)
},
{
DisplayName: "Next Month",
StartDate: DateAdd(
Date(Year(Now()),Month(Now()),1),
1,
Months
),
EndDate: DateAdd(
DateAdd(
Date(
Year(Now()),
Month(Now()),
1
),
2,
Months
),
-1,
Days
) }
)
)

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bbsin ,

Seems that you want to show all days between two given date in dropdown.

If yes, you code will not work. You can check the results and data structure of your collection. So for your question, I do a test on my side. For example, Today is 13/07/2021( Today() ), one month later is 13/08/2021( Date(Year(Today()), Month(Today())+1, Day(Today())) ) , I want to show 30 days between these two day, so here is the code:

With(
{startDate:Today(),
sequenceDays: Sequence(DateDiff(Today(),Date(Year(Today()), Month(Today())+1, Day(Today())), Days) + 1)
},
ClearCollect(colDates,
AddColumns(sequenceDays,
"Date",
DateAdd(startDate, Value - 1, Days)
)
))

Then in the dropdown, use this formula:

colDates.Date

Edit the code based on your actual requirement. I would suggest you create different collections for "This Week", "This month", "Previous month".

Best regards,

Allen

Was this reply helpful? Yes No