+6Hi,
I wanted to very simply use a tester to select all records that had a date in the past week. I have tried everything but it does not seem to work.
I have a date field in the correct format, I have also tried other formats via the date/time converter but it does not work.
@DateTimeNow()-7 does not work.
Anyone have any other suggestions?
Thx
Nathalie
Best answer by nielsgerrits
Unfortunately it doesn't work. Am I doing something wrong?
DateTimeNow returns a value as %Y%m%d%H%M%S, for example 20170203170000.1234567
If your Wijzigingsdatum is formatted as %Y%m%d then you have to reformat one or the other.
@Left(@DateTimeAdd(@DateTimeNow(),-P7D),8)
Will return 20240223 for today.
+31The code below will give you 7 days prior to the current date.
@DateTimeAdd(@DateTimeNow(),-P7D)
+6Unfortunately it doesn't work. Am I doing something wrong?
+54Unfortunately it doesn't work. Am I doing something wrong?
DateTimeNow returns a value as %Y%m%d%H%M%S, for example 20170203170000.1234567
If your Wijzigingsdatum is formatted as %Y%m%d then you have to reformat one or the other.
@Left(@DateTimeAdd(@DateTimeNow(),-P7D),8)
Will return 20240223 for today.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
