Cyprus-Forum.com

[CBBB]

Any of you Cyprus Forum Geniuses any good with Crystal Reports?

I've just started playing with it and have hit a brick wall with a data comparison.

The database I am querying stores dates as integers of the form YYYYMMDD so that 06/12/2013 is presented as the number 20,131,206!!!

As I don't want to have my users enter dates in that format, I need to convert either the database field to a normal date format or the user entered date to the database format, before I do my selection.

I've tried all sorts of stuff, but keep getting too complicated for CR.

Any suggestions anyone?

[Get Real!]

Any suggestions anyone?

Yes, learn basic SQL.

[Get Real!]

Basically the logic to convert from user input variables (say "Day", "Month", "Year") to the string version (you called it integer) is something like this:

IntegerDate = LeadingZero(Year,4) + LeadingZero(Month,2) + LeadingZero(Day,2)

If you don’t understand this basic pseudocode above forget it!

[Get Real!]

Here we go, SQL has a function that converts year, month, and day into Datetime!

http://stackoverflow.com/questions/1923 ... o-datetime

Have fun!

[CBBB]

Re GR! I was doing this stuff when you were still a little wombat! It is a specific solution for Crystal Reports that I am after. The logic is easy, it is just the implementation I am having trouble with.

[Get Real!]

Re GR! I was doing this stuff when you were still a little wombat! It is a specific solution for Crystal Reports that I am after. The logic is easy, it is just the implementation I am having trouble with.

I don't think so mate, I doubt you had even seen a computer when I was a professional programmer because the answer to your question....

I need to convert either the database field to a normal date format or the user entered date to the database format, before I do my selection.

...is this:


From integer date to D/M/Y

SELECT CONVERT(DATETIME, CONVERT(CHAR(8), IntegerDate))

From D/M/Y to integer date:

SELECT
CAST(
CAST(year AS VARCHAR(4)) +
RIGHT('0' + CAST(month AS VARCHAR(2)), 2) +
RIGHT('0' + CAST(day AS VARCHAR(2)), 2)
AS DATETIME)

Now if you don't know how to use this code that's another story!

[CBBB]

Re GR! I was doing this stuff when you were still a little wombat! It is a specific solution for Crystal Reports that I am after. The logic is easy, it is just the implementation I am having trouble with.

I don't think so mate, I doubt you had even seen a computer when I was a professional programmer because the answer to your question....

I need to convert either the database field to a normal date format or the user entered date to the database format, before I do my selection.

...is this:


From integer date to D/M/Y

SELECT CONVERT(DATETIME, CONVERT(CHAR(8), IntegerDate))

From D/M/Y to integer date:

SELECT
CAST(
CAST(year AS VARCHAR(4)) +
RIGHT('0' + CAST(month AS VARCHAR(2)), 2) +
RIGHT('0' + CAST(day AS VARCHAR(2)), 2)
AS DATETIME)

Now if you don't know how to use this code that's another story!

They had computers that long ago in the outback?

When I started working as a professional programmer (after completing my Computer Science studies) in 1974, you were probably still wondering what the thing between your legs was for!

As I said, I know what to do, it is getting Crystal Reports to do it!

[Get Real!]

They had computers that long ago in the outback?

When I started working as a professional programmer (after completing my Computer Science studies) in 1974, you were probably still wondering what the thing between your legs was for!

Programming in 1974 was probably LISP and FORTRAN which is as useful today as a Bernoulli drive is to an iPad!

As I said, I know what to do, it is getting Crystal Reports to do it!

I'll bet I can sort it in about 10 minutes if I was there, but I'm just gonna let you use FORTRAN to tackle the problem!

Bye-bye...

[CBBB]

They had computers that long ago in the outback?

When I started working as a professional programmer (after completing my Computer Science studies) in 1974, you were probably still wondering what the thing between your legs was for!

Programming in 1974 was probably LISP and FORTRAN which is as useful today as a Bernoulli drive is to an iPad!

As I said, I know what to do, it is getting Crystal Reports to do it!

I'll bet I can sort it in about 10 minutes if I was there, but I'm just gonna let you use FORTRAN to tackle the problem!

Bye-bye...

COBOLers to you!

I started using ALGOL 60 before I progressed to COBOL and Fortran.

[supporttheunderdog]

They had computers that long ago in the outback?

When I started working as a professional programmer (after completing my Computer Science studies) in 1974, you were probably still wondering what the thing between your legs was for!

Programming in 1974 was probably LISP and FORTRAN which is as useful today as a Bernoulli drive is to an iPad!

As I said, I know what to do, it is getting Crystal Reports to do it!

I'll bet I can sort it in about 10 minutes if I was there, but I'm just gonna let you use FORTRAN to tackle the problem!

Bye-bye...

COBOLers to you!

I started using ALGOL 60 before I progressed to COBOL and Fortran.

Come on boys, lets get back to BASIC.

C you soon.