Forum Discussion

KristyWilliford's avatar
KristyWilliford
Qrew Assistant Captain
7 years ago

I would like to add three working days to a date time field.How should I do it

QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
not tested but try this


var datetime MyDateTime = [my date time field];
var date MyDate = ToDate($MyDateTime ]);
var timeofday Time = ToTimeOfDay $MyDateTime;
var date  NewDate = WeekDayAdd($MyDate, 3)

ToTimeStamp($NewDate, $Time)

If there is a problem with the formula, please post the formula and the error message.





  • WaldoRemijn's avatar
    WaldoRemijn
    Qrew Member
    3 years ago
    Had to make a few technical changes to your formula but it works perfectly:

    var datetime MyDateTime = [my date time field];
    var date MyDate = ToDate($MyDateTime);
    var timeofday Time = ToTimeOfDay($MyDateTime);
    var date NewDate = WeekdayAdd($MyDate, 3);

    ToTimestamp($NewDate, $Time)

    ------------------------------
    Waldo Remijn
    Founder
    Go Improve Ltd
    Sevenoaks United Kingdom
    ------------------------------