We help IT Professionals succeed at work.

Dates formatted Differently on another pc

rporter45
rporter45 asked
on
165 Views
Last Modified: 2018-03-21
Good afternoon!  I have a 10 year fiscal evaluation report - I have created formulas for each year

if month ({?Current Fiscal Year Date To}) >= 7 then "FY"& totext ( year ({?Current Fiscal Year Date To})+1)
else  "FY" & totext (Year ({?Current Fiscal Year Date To}))

On my pc they are FY2017 but on another person's pc they return a value of FY2017.00

I've never seen this before - any help would be appreciated!

thanks - CS
Comment
Watch Question

Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
Worked perfectly! thanks very much!
cs