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?
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.