community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Help with error

Meteor

Hi,

I am trying to perform calculations involving a date time column [Start Date] and [Percentage Part Time] however I am getting this error.

Can anybody help me with this?Error.jpg

Highlighted
Alteryx Certified Partner

Hello,

 

Try putting quotation marks around the date,

 

DateTimeDay('2019-01-01')

 

Note that this is just going to give you the day part of this date, which is "1"!

 

Another way of getting percentage of the year is,

Percentage of Year - Capture.PNG

 

 

Labels