Forum Discussion

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

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
------------------------------
No RepliesBe the first to reply