I'm trying to add a few random days between two date fields.
I have start and end as two fields in yyyy-mm-dd format.
I have added the following formula to the end field.
start + days(random(1, 7))
This does produce the correct result but includes the time & UTC as well.
'2015-12-11', 2015-12-16 14:35:37 UTC'
Whereas I am hoping for
Is this expected, do I have to specify date %Y%m%d somewhere to trim it?
Thanks in advance.