Print Page | Close Window

Timestamp Dilema

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15933
Printed Date: 29 Apr 2024 at 12:43am


Topic: Timestamp Dilema
Posted By: ptroyer
Subject: Timestamp Dilema
Date Posted: 20 Mar 2012 at 2:56pm
A program which I keep a database for has changed there registration rules and This has forced me to add a timestamp field to a small table in the database.  I then went through an painstakingly added a approximate timestamp to each of the old records.  My problem is that beyond a certain date I can not get my report to return records.  I have checked the MSQL database and do not observe any problems.

 SELECT `Triggers`.`Date`, `Triggers`.`MMID`, `Demographics`.`First`, `Demographics`.`Last`, `Demographics`.`Phone`, `Demographics`.`Mobile`, `Demographics`.`City`, `Triggers`.`Trig`, `Triggers`.`TKey`
 FROM   `hra_triggers`.`Demographics` `Demographics` INNER JOIN `hra_triggers`.`Triggers` `Triggers` ON `Demographics`.`MMID`=`Triggers`.`MMID`
 WHERE  (`Triggers`.`Date`>={ts '2012-03-19 07:53:56'} AND `Triggers`.`Date`<{ts '2012-03-20 07:25:42'})
 ORDER BY `Triggers`.`MMID`

This query works if the begin data is before 03-14 it will return rows up to the 14th.  PHPMyAdmin gives the same result.  There are some 800 records past the 14th.  What really gets me is that this query work against the same database regardles of the dates

http://192.168.10.154/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.1%2Fen%2Fselect.html&token=48b72dee05effd9e59ab6b459e711326 - - SELECT *
FROM `Triggers`
WHERE (
`Triggers`.`Date` >= {ts '2012-03-13 07:53:56'}
AND `Triggers`.`Date` < {ts '2012-03-20 07:25:42'}
)

Any thoughts I am confused.Confused


Replies:
Posted By: ptroyer
Date Posted: 20 Mar 2012 at 3:29pm
Other information about this when I create my parameter fields they insist on pulling up each individual import into the database and do not give me a calendar like I am acustomed 


Print Page | Close Window