In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

DateTimeAdd, is there an option to just "DateAdd" without timestamp?

wonka1234
10 - Fireball

Hi,

 

DateTimeAdd, is there an option to just "DateAdd" without timestamp?

 

Thanks.

3 REPLIES 3
ShankerV
17 - Castor

Hi @wonka1234 

 

If the dataset is without time stamp, i.e in date format yyyy-mm-dd then it will add without time stamp.

 

We do not have separate DateAdd, but DateTimeAdd can add dates without time stamp too.

 

Many thanks

Shanker V

wonka1234
10 - Fireball

@ShankerV  it is in yyyy-mm-dd but it is a "date" type. whereas my datetimeadd is a string!

ShankerV
17 - Castor

Hi @wonka1234 

 

Please use datetimeparse() to convert into date format.

 

It can be used inside the datetimeadd(datetimeparse(),1,"days").

 

Hope this helps!!!

 

 

Many thanks

Shanker V

Labels
Top Solution Authors