Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Help on the parsing dates and times video

shyamraman
8 - Asteroid

Hello everyone,

From  the video Live Training - Parsing Dates and Times - YouTube

 

At 47:43 this expression is used: "This bill is"+[Years old]+" and "+[days extra]+"old"

 

However i am getting a unmatched quote error. What am I doing wrong?

 

Thank you

Shyam

4 REPLIES 4
BrandonB
Alteryx
Alteryx

This means that in your formula you don't have the ending quote to finish a string like this:

 

quote.png

shyamraman
8 - Asteroid

shyamraman_0-1607714114352.png

That was the first thing I checked, but I do have the quotes at the end..

BrandonB
Alteryx
Alteryx

Ah this isn't an unmatched quote error though. This is because you need to make sure that the fields are strings to add them together, or you can wrap them in a ToString([Field])

shyamraman
8 - Asteroid

That was AWESOME! It works now!

Thank you!!! 😀

Labels