Add DateTIme Wihout Time STamp

[Pankaj_G]

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 

[binuacs]

@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

[Pankaj_G]

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

[grazitti_sapna]

@Pankaj_G , For EndDate you can use 

todate(DatetimeParse([End Date],"%m/%d/%Y %I:%M %p(add your format here)"))

[binuacs]

@Pankaj_G Changing the data type to Date works for me

[Pankaj_G]

Can you do this on attached data, I still see Null in place of End Date

[grazitti_sapna]

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.

[binuacs · Accepted solution]

@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

[Pankaj_G]

Thanks guys, I have got the solution for this.