How to extract just the date part after adding some days to now()

#1

I have this to generate an end date now() + days(random(10,20))
its returning dates as expected 2018-04-18 06:52:10 but including the time
I only want the date portion, how do i exclude the time

.to_date problem
#2

@nhills
Use the .to_date function:

(now() +days(random(10,20))).to_date

see example:

#3

Excellent, thanks, just what I needed