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

Date formatting

Albert2107
7 - Meteor

Hi All,

 

I am new in Alteryx and this is just a very basic question. I am trying to calculate the no. of working days between two dates. I am wondering how is the correct format on writing a date in the formula tool? this is what my formula looks like and it doesn't calculate correctly or it errors since the supposedly dates (8/1/2019 and 7/31/2020) are not in date format. 

See image below.

Albert2107_0-1636620495536.png

 

 

Warm regards,

Albert

12 REPLIES 12
Albert2107
7 - Meteor

Thanks! @Christina_H, I'll try this one and will get back if ever I have some trouble.

 

Warm regards,

Albert

Albert2107
7 - Meteor

Hi @Christina_H,

 

Thank you so much! This one really works with little updates on the condition, this helps me a lot.

 

Warm regards,

Albert

amruthas2
8 - Asteroid

@Albert2107 

 

Link for your future reference

 

DateTime Functions | Alteryx Help

Labels