News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Calendar

Power Apps - Building Power Apps

Unanswered

Calendar

(0) Share

Report

Report

Posted on by CU04112231-0

I am entering this formula:

Set( monthStart; Date( Year(Today()); Month(Today()); 1))
 
But for any reason it gives me error

Categories:

General Questions

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

timl 31,946 on at

Like (1)

Report
Calendar

Yes, as I mentioned in my earlier post, double semi colons are needed between the lines (except for the last line)

// Get the start of the month Set(monthStart; Date(Year(Today()); Month(Today()); 1));; // Get the end of the month Set(monthEnd; DateAdd(DateAdd(monthStart; 1; "Months"); -1; "Days"));; // Get first date in view Set(firstDateInView; DateAdd(monthStart; -Weekday(monthStart); "Days"))
Suggested answer

KBpwr 55 on at

Like (0)

Report

Calendar

Update: Sounds like there is indeed a operators difference pointed out by another user so that should fix this.
Suggested answer

timl 31,946 on at

Like (1)

Report
Calendar

Hi CU04112231-0

There should be 2 semi-colons (;;) between the formulas.

It would look something like this:

Set( monthStart; Date( Year(Today()); Month(Today()); 1));; Set( monthEnd; DateAdd(DateAdd(monthStart; 1; Months); -1;Days));; Set(firstDateInView.......

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing Mentions and Quick Responses!

Give Back to the Community this Month

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

WarrenBelz 143,246

#2

RandyHayes 76,308

#3

Pstork1 63,884

Leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value

How to patch multiple records at once

Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans