Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field that I am calculating in my script and I can't seem to get the format correct. Here is the code in my script to create the field:
Num(MonthsEnd(1,Today(),-1)-[Posting Date],'#,##0') as DaysAged
I want this to be a number without decimals. When I look at the values in a list box, it looks fine, but when I export the data to Excel, I still see the decimals. How can I make it a whole number when exporting to Excel?