I cannot figure this one out.
I get the error when i try to convert at string i a have previously split and trimmed
You can see the converting assign activity gets the input: “13-02-2020” When looking in the local pane. So how is that I cannot convert it? heres how I convert:
First check your input date is in which format.
Try this. It will convert any type string date format to required string format.
I get the same error event though i dont split the string
Did you mean to convert the string to string? as shown below, in that case I recieve another error
Display the input date in message box and send the screenshot of it.
Not the type , display input date.
@ChrisPals I think it’s Better if you Display Like this :
“A”+newString+“B” inside the message Box
I know it’s weird but we get Confirmation of what is the real format in the String
Remove double quotes and it should be like this.
newDateStr = CDate(newstring).Tostring("dd-MM-yyyy")
Same issue unfortunately!
@ChrisPals Then the Expression what you had used to Convert Should be Fine, Can you Tell me what you want to do actually ? I can see your Converting String to Date but again you’re converting it into String , I Did’nt Understand Why?
@ChrisPals Can you just Check if this works :
This worked fine for me
get stringdate with get text>split so I only have the date and not the time>convert to datetime.
The assign converting from newstring to the datetime variable ‘lastedit’ should be the last step.
I tried that one.
But I recieve this error:
@ChrisPals If you want it in Date Type Format , Remove .ToString(“dd-MM-yyyy”)
ah ok! thanks alot, It works perfectly now.
Cant believe I didn’t catch that myself