Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with date format when localising

Status
Not open for further replies.

Sinead

Programmer
Aug 3, 2001
14
IE
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top