Jump to content

Auto Enter Date to Skip Weekend


 Share

This topic is 5754 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Is there a formula I can use that when run will calculate a date, but if the date falls on a weekend it will oush the result to the next weekday.

Example I want to set an "Order_due" field to be current_date+7. If I create that record today order will be marked as due next sunday (a non work day) but would like the result to show as Monday the 26th?

Thanks in advance for any help.

Steve

PS I love the calendar function in the new version!

Link to comment
Share on other sites

the way id do it is fairly simple... using a static order period of 7 days though you could just as easily make it dynamic...and a field called OrderDate.. i.e. the date the order is placed and a field called OrderDue and one called OrderDueDisplay so as not to clutter the OrderDue Calc...

FIELD: OrderDue (Calc with result date)

Case (DayName (OrderDate + 7) = "Saturday"; OrderDate + 9;

DayName (OrderDate + 7) = "Sunday" ; OrderDate + 8 ;

OrderDate + 7)

FIELD: OrderDueDisplay (Calc with result text)

DayName ( OrderDue ) & " " & Day ( OrderDue ) & " " & MonthName ( OrderDue )

Genx

Link to comment
Share on other sites

the way id do it is fairly simple

That doesn't seem very simple... How about this one by Queue:

Let (

dueDate = OrderDate + 7

;

dueDate + Position ( "17" ; DayOfWeek ( dueDate ) ; 1 ; 1 )

)

There's no need for a second field - you can format a date field to display any way you like.

Link to comment
Share on other sites

This topic is 5754 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Who Viewed the Topic

    1 member has viewed this topic:
    dataclip 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.