Date formatting

[Albert2107]

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.

Warm regards,

Albert

[Albert2107]

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

Warm regards,

Albert

[Albert2107]

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]

@Albert2107 

Link for your future reference

DateTime Functions | Alteryx Help