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

Samira_123
Samira_123 New Altair Community Member
edited November 5 in Community Q&A
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 :smile:
Tagged:

Best Answer

  • BalazsBarany
    BalazsBarany New Altair Community Member
    Answer ✓
    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

Answers

  • BalazsBarany
    BalazsBarany New Altair Community Member
    Answer ✓
    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
  • Samira_123
    Samira_123 New Altair Community Member
    Good afternoon Balazs, 

    Thank you for your answer. It solved my problem :)




Categories