Date field calculation (Adding or substracting days, weeks, etc)

Question & Answer
, , , , ,
1

Greetings team.

Is possible to somehow add or substract days from a Date field in QS?
For example have a field that adds 7 days to a date specified in another field.

Kind of the result yo get in excel using the formula below.

=[@[date]]+7
[2/20/2023]+7= 2/27/2023

Appreciate your help in advance.

2

You can use the addDateTime function with period 'DD' to add days to an existing field.

2 Likes
3

That worked as expected. Thank you, darcoli!

1 Like