Change Date Picker Default Date

[jkniffen]

Hi,

Is there a way to change the Date Picker Default Date?  What I would like to show as the default date is the current date plus 5 business days.  Is this possible?

Thank you for your help.

Joe

[gabibalaban]

@jkniffen ,

Set the default date property of the control to:

DateAdd(Today(),5,Days)

hope it helps !

[eka24]

DefaultDate:

Today() + 5

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[jkniffen]

Thank you very much for your help.   🙂  Your formula works great but I need to only count business days and not weekends.  Is that possible?

[jkniffen]

Thank you very much for your help.   🙂  Your formula works great but I need to only count business days and not weekends.  Is that possible?

[eka24]

Check this tutorial from Reza Dorani:

https://youtu.be/QVvhDe6puq0?t=31

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[eka24]

Check this tutorial from Reza Dorani:

https://youtu.be/QVvhDe6puq0?t=31

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[timl · Accepted solution]

@jkniffen 

Here's a formula that will calculate todays date + 5 business days.

With({ startDate:Today(),
       daysToAdd: 5
      },
      DateAdd(startDate, daysToAdd) + 
      RoundDown(daysToAdd/5, 0)*2 +
      Switch(Weekday(startDate, StartOfWeek.Monday),
             5,If(Mod(daysToAdd, 5)>0,2,0),
             4,If(Mod(daysToAdd, 5)>1,2,0),
             3,If(Mod(daysToAdd, 5)>2,2,0),
             2,If(Mod(daysToAdd, 5)>3,2,0),
             1,If(Mod(daysToAdd, 5)>4,2,0)
      )
)

I have a post that describes how this formula works.

http://powerappsguide.com/blog/post/formulas-how-to-cope-with-weekends-public-holidays-in-date-calcu...

Also, you might consider voting for my idea here to include a built-in function to calculate business days.

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Provide-a-function-to-add-or-subtract-working-d...

[jkniffen]

Thank you very much for your help.   🙂

[jkniffen]

Thank you so much for your help.  Impressive code and works awesome!  Thank you again!