Erin Leale
asked on
Crystal Reports - String Year Field to Date for Compare
I have a database field that is Fiscal Year - I need to make this field an actual Date field so I can compare to Current Date data and Prior Year data. Is there a way to accomplish this?
Thank you.
Thank you.
ASKER
2015
If it is a number you could just compare the years
{FIscal Year} = Year({DateField})
Are you trying to group on the field?
mlmcc
{FIscal Year} = Year({DateField})
Are you trying to group on the field?
mlmcc
ASKER
No - I need to make a calculation based on the Fiscal Year to the current year.
If I use the example above it gives an error because the Fiscal Year field is a string.
I think I need to create an actual Date field based on Period and Year then see if I can compare the years. Thoughts?
If I use the example above it gives an error because the Fiscal Year field is a string.
I think I need to create an actual Date field based on Period and Year then see if I can compare the years. Thoughts?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What data is in the Fiscal Year field?
mlmcc