TOPIC: Date Error

Date Error 23 Jun 2015 10:41 #1985

  • Andydavidluke
  • Andydavidluke's Avatar
  • Offline
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
The administrator has disabled public write access.