Hi All,
In my crystal report, I have created a date formula from a string which is YYYYMMDD and then the date is read here in the UK as DDMMYYYY. When I run this through Logicity, I believe it is trying to read the DD as the month as I get an error saying the month number must be between 1 and 12, when I change the format, it then throws the report out as my Crystal report then questions the date saying a month number must be between 1 and 12. This is causing me brain pain, is there a way around this as all I believe it to be is due to the difference in format of the date i.e. America MMDDYYYY / UK DDMMYYYY
Is there anyway there could be a UK date setting in Logicity?
Many thanks,
AJ