Generate datetime values relative to today

I’m sure this will be possible but I haven’t figured it out yet… is there a way to generate a datetime value within a range relative to today i.e. always within the last 14 days?

I’m currently using the DateTime data type but have to specify a start and end date range, but I always want dates to be within the last two weeks and am trying to avoid having to manually update the range each time I need it.

Any ideas?

1 Like

Select field Type formula the enter
(now() - days(random(0,14)) - hours(random(0,59)) - minutes(random(0,59)) - seconds(random(0,59)))

Perfect! Thanks for the nudge.

How can I use the formula for the filed todays date(inrollment date) current date, please let me know if we can use formula for this.

How can I use the formula for the filed todays date(inrollment date) current date, please let me know if we can use formula for this.