How can I change the actual day or create a new date for the database?

Hi,
I have an issue with my performance. I have to do a classification to predict which donors will donate.
How can we add/create a new date to say for example that the date of today is 2016-12-31.
I want to do this to be able to use the 'date_diff ' and compute how many days have passed since the last donation and this new date.

Thank you

Find more posts tagged with

AI Studio

Classification

Databases

Dates + Times

Accepted answers

BalazsBaranyRM

Hi,

check out the date_now() function. It returns the current time. There are more time-related functions in Generate Attributes, the documentation is right there in the dialog box.

Regards,
Balázs

All comments

BalazsBaranyRM

Samira_123

Good afternoon Balazs,

Thank you for your answer. It solved my problem