GuyHamasaki
MIS
Is it possible to use date parameters to select the range of data you want to appear on your report when the datasource is an excel spreadsheet?
Thanks in advance...Guy
Thanks in advance...Guy
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using date parameters with an excel spreadsheet datasource
- Thread starter GuyHamasaki
- Start date
- Status
I would guess so however I have never tried it.
One thing I would try if you run into trouble. Have oyu noticed how, in excel, the "raw data" of the data is a number? For example type 37318 in a cell, and format it to date, and you get 03/03/02. This is called (or so I am told) a julian date. There is a julian date to date UFL on the Crystal Decisions website. If you might run into problems, download that UFL, convert the dates and try it again.
Let me know if this is an issue. I rarely work with excel as a data source (thank god) so I have never tested this julian date to date function. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com
One thing I would try if you run into trouble. Have oyu noticed how, in excel, the "raw data" of the data is a number? For example type 37318 in a cell, and format it to date, and you get 03/03/02. This is called (or so I am told) a julian date. There is a julian date to date UFL on the Crystal Decisions website. If you might run into problems, download that UFL, convert the dates and try it again.
Let me know if this is an issue. I rarely work with excel as a data source (thank god) so I have never tested this julian date to date function. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com
- Status
Similar threads
- Locked
- Question