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]

@chukleswk 

getting nulls now..

befre:

after:

[chukleswk]

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]

@chukleswk 

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

[chukleswk · Accepted solution]

Change you date formula to: 

 

[wonka1234]

@chukleswk this seemingly works!

[chukleswk]

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

[wonka1234]

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

[chukleswk]

@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.