DateTimeDiff, rounding help

[wonka1234]

Here is what I get in excel:

excel formula - =(V13-V11)/365.25

what im trying in alteryx:

DateTimeDiff([Maturity Date],[Run Date],"month")/12

but i am getting 7.0 . 

Is there a way to round this to get 6.50 like in excel?

[wonka1234]

@chuckleswk 

getting nulls now..

befre:

after:

[chuckleswk]

Can we get a browse so we can see what the output for the date from the dynamic rename looks like? Also, check that you are running a trim or a Data Cleansing tool to make sure that you don't have any leading / trailing whitespaces.

[wonka1234]

@chuckleswk 

whats interesting the header names do have spaces before i convert them:

[chuckleswk · Accepted solution]

Change you date formula to: 

 

[wonka1234]

@chuckleswk this seemingly works!

[chuckleswk]

Glad to hear that. Did it produce the decimal point that you were looking for?

[wonka1234]

@chuckleswk  Yes it did! not sure why that format changed it though

[chuckleswk]

@wonka1234 It's because you are selecting the format that the input currently is in. You did a Custom format with mm/dd/yyyy which you could have done if you had used MM/dd/yyyy instead. The lowercase "mm" changed it to the first of the year.