Link to home
Start Free TrialLog in
Avatar of rporter45
rporter45

asked on

Dates formatted Differently on another pc

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
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rporter45
rporter45

ASKER

Worked perfectly! thanks very much!
cs