Add DateTIme Wihout Time STamp

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

Developer

Developer Tools

Date Time

Accepted answers

binu_acs

@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

Multi-Row_1019.yxmd

All comments

binu_acs

@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)"))

binu_acs

@Pankaj_G Changing the data type to Date works for me

Multi-Row_1019.yxmd

Pankaj_G

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

TLI schema.xlsx

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.

Multi-Row (2).yxmd

binu_acs

@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

Multi-Row_1019.yxmd

Pankaj_G

Thanks guys, I have got the solution for this.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317