sgaurav7
asked on
Convert ToNumber
Hello,
In my prompt option, when I type "10" for 2010, it is not returning the 2010 values. The formula that references the ?Year is below:
ToNumber(Right(ToText(Year ({ap_invoi ce_detail. trans_date })),4)) = ToNumber({?Year})
It has worked great until 2009 but for 2010 it doesn't look like it is converting it to string correctly. The formula seems to be ok but I am not sure why it is not returning 2010 records in the output?
In my prompt option, when I type "10" for 2010, it is not returning the 2010 values. The formula that references the ?Year is below:
ToNumber(Right(ToText(Year
It has worked great until 2009 but for 2010 it doesn't look like it is converting it to string correctly. The formula seems to be ok but I am not sure why it is not returning 2010 records in the output?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I tried both formulas and they both worked. Thanks!