https://community.sap.com/t5/technology-q-a/a-string-is-require-here/qaa-p/12761905#M4790708 <P>I suspect that your ShipDate field is stored in the database as a string. This means that the Crystal functions that work with dates won't work with it directly - it needs to be converted to a date data type first. If you'll post an example of how the ShipDate data looks, I can give you the formula you need.</P><P>-Dell</P> Thu, 26 Oct 2023 14:07:44 GMT DellSC 2023-10-26T14:07:44Z https://community.sap.com/t5/technology-q-a/a-string-is-require-here/qaq-p/12761904 <P>Please can anyone help with with the following problem - </P> <P>{shiphead.ShipDate} in WeekToDateFromSun - error A String is require here. "WeekToDateFromSun"</P> <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/2224575-image.png" /></P> <P>Thanks you all and good day!</P> Thu, 26 Oct 2023 08:43:56 GMT https://community.sap.com/t5/technology-q-a/a-string-is-require-here/qaq-p/12761904 lee10 2023-10-26T08:43:56Z https://community.sap.com/t5/technology-q-a/a-string-is-require-here/qaa-p/12761905#M4790708 <P>I suspect that your ShipDate field is stored in the database as a string. This means that the Crystal functions that work with dates won't work with it directly - it needs to be converted to a date data type first. If you'll post an example of how the ShipDate data looks, I can give you the formula you need.</P><P>-Dell</P> Thu, 26 Oct 2023 14:07:44 GMT https://community.sap.com/t5/technology-q-a/a-string-is-require-here/qaa-p/12761905#M4790708 DellSC 2023-10-26T14:07:44Z