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

[wonka1234]

Hi,

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

Thanks.

[ShankerV]

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]

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

[ShankerV]

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