adding eg 7 days to a date+time field

Kruna Try

datetime(year('Date + Time'), month('Date + Time'), day('Date + Time') + 7) + time('Date + Time')

Kruna Silly me. I didn't follow the docs myself. You can only use numbers in datetime().

So you have to do a bit of math to get the hour and minutes into a human readable form.

Try:

let h := floor(number(time(Terminbeginn)) / 3600000);
let m := (number(time(Terminbeginn)) - 3600000 * h) / 60000;
Terminbeginn := datetime(year(Terminbeginn),month(Terminbeginn),day(Terminbeginn)+7,h,m)

The math behind lines 1 and 2 is that there are 3,600,000 milliseconds in an hour and 60,000 milliseconds in a minute. So h finds the number of hours then m subtracts the total number of milliseconds hours then divides by 60,000 to find the number of minutes in Terminbeginn.

John Halls I get an function not defined error message of number, number, string.

Fred Hi Fred, worked for me. datetime(number, number, number) gives the date plus 00:00:00, and then I just added the time element to this.

John Halls Of course, I put my parenthesis in the wrong place. I was trying to do something like this. Thanks for the simpler way.