Formula Between A String And A Date

[quims]

Hi Atleryx Community,

I'm having issue when transferring my working file to alteryx. The composition of formula are string and date. 

Below is my formula in excel format:

=IF(E2="Cr",(I2-C2),IF(E2="Dr",(I2-D2),"CHECK DR & CR"))

Thanks in advance.

[JosephSerpis · Accepted solution]

Hi @quims I mocked up a workflow that replicates your formula. Let me know what you think?

[quims]

Great help, @JosephSerpis 

So much helpful!

thank you!

-quims