Hi,
I am trying to search for records between certain dates to be displayed in a Crystal Report using vb application. If I use the date format 'dd/mmm/yyyy' in the record selection formula, I get the correct results. My problem is that I must localise it. If for example I search using 10/Dez/2001 (having changed the format from 10.Dez.2001, the date time literal is not understood, even though the language setting is German.
Since Crystal reports uses whatever dateformat in the settings, I am getting the date format settings at the start of my vb application and using this in the string selection formula. I am also getting an error stating that 'the date time literals are not understood' if I use the format 10.12.2001. Is this because the string selection formula does not support dates with '.'
Please help somebody!
I am trying to search for records between certain dates to be displayed in a Crystal Report using vb application. If I use the date format 'dd/mmm/yyyy' in the record selection formula, I get the correct results. My problem is that I must localise it. If for example I search using 10/Dez/2001 (having changed the format from 10.Dez.2001, the date time literal is not understood, even though the language setting is German.
Since Crystal reports uses whatever dateformat in the settings, I am getting the date format settings at the start of my vb application and using this in the string selection formula. I am also getting an error stating that 'the date time literals are not understood' if I use the format 10.12.2001. Is this because the string selection formula does not support dates with '.'
Please help somebody!