cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FelipeCaru
Advocate V
Advocate V

Updating dates using change in another gallery; having dates of this week/this month

Hello all,

I want to ask some questions I currently have: Is it possible to have some way to get dates of this week? For example, I have different tasks each day of a month, and I want to filter to show this week only, how could I go doing that? In the case for showing by this month, would some function like MONTH(Today()) = MONTH(<date>) work?

 

The second part of the question is: I have task from a project, where the start and end date of 'parent' task are based on the start/end date of the subtasks on it. For example:

ProjectTaskSubtaskSub subtaskStart dateEnd date
LP   17-04-201818-06-2020
 Approvation  17-04-201818-07-2018
  Start project 17-04-201817-04-2018
  Business meeting 18-04-201817-05-2018
  First submission 04-06-201818-07-2018
 Execution  18-04-201818-06-2020
  Ground mechanic 18-04-201801-07-2018
  Land buying 18-05-201803-12-2018
   Counterpart meeting18-05-201801-07-2018
   Alcohol buying04-06-201802-08-2018
   Delivery03-12-201803-12-2018
  Go date 14-06-202018-06-2020
   Preparation14-06-202016-04-2020
   Opening-finish17-06-202018-06-2020

As can be seen, the project start/end date is based upon the start/end date of its task/sub task/sub subtask. In this case, the start date of "LP" is the minimum date of the items in "task" and end date is the max of those items. In the same way, the minimum date of the items in "task" is based upon the ones in "subtask" and, if have another level, in subsubtasks. What I want to know, is there some way so if for example, I changed the "Opening-finish" end date, it would automatically update that date in "go date" (for example, it is now 19-06-2020), and since it is a new 'max',  it would change the end date of 'execution' and then the one of the project itself.

22 REPLIES 22

@RandyHayes 

In a gallery, actually. For some reason now that I have closed/opened the app, I can select the proper item ('Comienzo Plan' or 'Fin Plan'), but before that it only showed datacards from other screens.

For anyone wanting to know end formula, will post image following this text, since in 'code bar' ends not readable, IMO.

Code:

formulaWeek.png

@FelipeCaru 

So it sounds like the ol' "things are not working like they should" - "exit and then go back in, and all is better" syndrome.

I assume then it is working properly for you now?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

@RandyHayes 

Should get a better shorter name for that haha. But yes, it is working alright now (:

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (18,475)