Skip to main content
Question

Remove Weekends between datetime and days, Then show datetime

  • February 24, 2023
  • 0 replies
  • 87 views

"I have two fields in my Quickbase application: Request Received Date (a datetime field) and TAT (a numeric field). These fields will be populated based on user input, and I want to add the number of workdays specified in the TAT field to the Request Received Date field. The result should be displayed as a datetime value in a third field. However, I need to exclude weekends from the calculation."

I am currently using a formula to display a datetime value in a third field  ([Request Received Date]) + Days([TAT])



------------------------------
manohar vankireddy
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    try this

    var text RequestDueDate = WeekDayAdd(ToDate([Request Received Date]), [TAT]);

    var text RequestDueTime = ToTimeOfDay([Request Received Date]);

    ToTimeStamp($RequestDueDate, $RequestDueTime) 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement