Answered

Formula Help

(0) Share

Report

Posted on by Pagie

Can someone please tell me why my formulas dont work?

Set(_CurrentDate,Today());
Set(_DateSelected,_CurrentDate);
Set(_FirstDayofMonth,DateAdd(_DateSelected,1 -Day(_DateSelected,TimeUnit.Days));
Set(_FirstDayinView, DateAdd(_FirstDayofMonth,Weekday(_FirstDayofMonth)-2+1),TimeUnit.Days));
Set(_LastDayofMonth,DateAdd(_FirstDayofMonth,1,TimeUnit.Months),-1,TimeUnit.Days));
Set(_MinDate,DateAdd(_FirstDayofMonth,-(Weekday(_FirstDayofMonth)-2+1),Days));
Set(_MaxDate,DateAdd(_FirstDayofMonth,-(Weekday(_FirstDayofMonth),-2+1),Days)42,Days)))

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pagie,

Can you please post the errors you are getting.
Pagie 20 on at

Like
a
(0)

Report
Copy link

Link copied!
AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Pagie

These formulas look like they are coming from the Calendar template? Can you please send a screen shot of the code in the OnVisible property of your 'Main Screen'
Pagie 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Yeah i was following the video trying to learn.
Verified answer

AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Pagie

Try this

Set(_CurrentDate, Today());
Set(_dateSelected, _CurrentDate);
Set(_firstDayOfMonth, DateAdd(_dateSelected, 1 - Day(_dateSelected), TimeUnit.Days));
Set(_firstDayInView, DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1), TimeUnit.Days));
Set(_lastDayOfMonth, DateAdd(DateAdd(_firstDayOfMonth, 1, TimeUnit.Months), -1, TimeUnit.Days));
Set(_minDate, DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1), TimeUnit.Days));
Set(_maxDate, DateAdd(DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1), TimeUnit.Days), 40, TimeUnit.Days));

Your code was missing:
A closing bracket after _dateSelected variable for the Day function
An extra DateAdd( Function in both the _lastDayOfMonth and _MaxDate variable

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C