DateTimeAdd, is there an option to just "DateAdd" without timestamp?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
wonka1234
10 - Fireball
‎02-24-2023
11:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
DateTimeAdd, is there an option to just "DateAdd" without timestamp?
Thanks.
Labels:
- Labels:
- Custom Tools
3 REPLIES 3
ShankerV
17 - Castor
‎02-24-2023
11:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎02-24-2023
11:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ShankerV it is in yyyy-mm-dd but it is a "date" type. whereas my datetimeadd is a string!
ShankerV
17 - Castor
‎02-24-2023
11:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
