Add DateTIme Wihout Time STamp
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am using this below FOrmula in MultiRow Tool
IF [Pack Id] = [Row+1:Pack Id] THEN DateTimeAdd([Row+1:Price Start Date2],-1,'days') elseif [Pack Id] != [Row+1:Pack Id] THEN ([End Date]) ELSE "" ENDIF
In output I am getting time stamp added but I don't want time stamp to be there in the output
Referer the below Image and I want to handle this exception in the Multi Row tool itself
Solved! Go to Solution.
- Labels:
- Date Time
- Developer
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Pankaj_G Select the Date type from the Multi-Row tool drop-down
OR update your formula with the toDate function
IF [Pack Id] = [Row+1:Pack Id] THEN toDate(DateTimeAdd([Row+1:Price Start Date2],-1,'days')) elseif [Pack Id] != [Row+1:Pack Id] THEN toDate(([End Date])) ELSE "" ENDIF
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Doesn't seems to be working, So this part elseif [Pack Id] != [Row+1:Pack Id] THEN toDate(([End Date])) ELSE "" ENDIF Here the END Date is in string form altready so in Multi Row Output these cells are getting converted to null
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Pankaj_G , For EndDate you can use
todate(DatetimeParse([End Date],"%m/%d/%Y %I:%M %p(add your format here)"))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you do this on attached data, I still see Null in place of End Date
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Pankaj_G , Please use the updated workflow. For End Date you need to change it to date type and then use it. Excuted it on teh data you provided.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Pankaj_G The End Date is string type, you need to change it into Date type using the DateTimeParse() function
IF [Pack Id] = [Row+1:Pack Id] THEN DateTimeAdd([Row+1:Price Start Date2],-1,'days') elseif [Pack Id] != [Row+1:Pack Id] THEN DateTimeParse([End Date],'%d/%m/%Y') ELSE "" ENDIF
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks guys, I have got the solution for this.