Converting a text to a date

[Gerundino]

Greetings all,

New to the world of Crystal Reports, and I am already hitting my head due to a nuance with our CRM. The date fields in the tables from our CRM are a number, which is the equation of all seconds since January 1, 1970. I have tried editing the query to use the dateadd function (in SQL views and such, i usually just write DateAdd(s,table.field,'01-01-1970'). And, as you can guess by me writing, I have been unable to find a right way to do this. Would any more experienced members have an idea for me?

Thanks,

Gizmo

___________________
Thought of the moment:
A Freudian slip is when you say one thing but mean your mother.

 

[lbass]

Try:

dateadd("s",{table.field},date(1970,01,01))

-LB

 

[Gerundino]

Thanks LB,

I got past the immediacy by writing a view in SQL and pulling the report from there. After your email, I went in to put this in, and noticed I have no idea how to edit the SQL in Crystal. I tried the select expert, but it is looking for boolean (like i said, I am new....just installed last night...). Thanks again,

Nik

___________________
Thought of the moment:
A Freudian slip is when you say one thing but mean your mother.