Format Number

[mr moe]

I have a query that looks like this, datediff("d",[end_date],[start_date])/30
it's working perfect, but it's give me a decimal number, how can I formate it to get rid of the decimals, if I put "m" instead of the "d" than this number won't be accurate, can someone help? thanks.

 

[boblarson]

datediff("d",[end_date],[start_date])\30
use the backslash instead as it will give you a whole number.

 

[mr moe]

thanks Sir, you're good.