topic Re: Unable to fix the issue in University Forum

Unable to fix the issue

Adnan3194 — Mon, 02 Dec 2024 08:25:18 GMT

i am creating a process BP Travel, and i stuck at this this stage of Create Process, the error is displayed. i attach screenshot for reference. can someone guide me how to fix it,

Re: Unable to fix the issue

michaeloneil — Mon, 02 Dec 2024 09:12:24 GMT

Hi @Adnan3194

Im assuming what you are doing here is reading a value from the site you are working on and the date value you are having trouble interpreting is the value taken from the site?

If thats the case it looks like the value you are receiving has some single quotes in there so you may want to look at doing a calculation stage to remove these and any white space as well. The calculation would look something like this ToDate(Trim(Replace([Data1],"'","")))

Write the value back to a data item and it should be work from there. You could make sure the new data item you write back to is set as a date value.

Hope this helps

Re: Unable to fix the issue

EricNewton — Mon, 02 Dec 2024 14:12:38 GMT

Looks like the Create Quote action you are calling takes in 2 date values but I am assuming they are text in your Item Data collection. If that is the case then BP is trying to cast the text into a date. My guess is BP is using the same ToDate conversion function that you see in the calculate stage so is expecting a text format of "M/d/yyyy" but looks like your format is "d/M/yyyy".

So I think you need to do some additional calculation some where to either convert those text date values to "M/d/yyyy" format or make you current text value an actual date value and pass that to the Create Quote action.

So something like MakeDate("14", "12", "2024") or ToDate("12/14/2024") and using text functions like Mid, Left, Right to get the actual text details you need from the Item Data fields example Mid([Item Data.Depature Date], 4, 2) would give you the month number if the date format is "dd/MM/yyyy"

Re: Unable to fix the issue

Mohamad_Dakkouri — Mon, 02 Dec 2024 20:36:11 GMT

Hi @Adnan3194

Can you make a screenshots of your Collection Itemdata and show us the Departing date and the returning date please ?

Re: Unable to fix the issue

Adnan3194 — Wed, 04 Dec 2024 09:36:06 GMT

HI. I SOLVED THIS ISSEU. THANK YOU FOR YOUR SUPPORT.

Re: Unable to fix the issue

Adnan3194 — Wed, 04 Dec 2024 09:37:48 GMT

I MADE THE COLLECTION AND SELECT TEXT TYPE IN DATE. THAT'S WHY THE ERROR DISPLAYED. IN COLLECTION I MADE THE CHANGES DATE TYPE AS DATE.

THANK YOU FOR YOUR SUPPORT. ITS VERY MEAN TO ME.

Re: Unable to fix the issue

Adnan3194 — Wed, 04 Dec 2024 09:38:17 GMT

THANK YOU FOR YOUR SUPPORT. ITS VERY MEAN TO ME.