Parameters and Julian Dates

[MegOBytes]

CR XI
SQL 2005

If my database date values are stored as Julian and I create a parameter to select on the date field, how do i get the dates to show in mmddyyyy format?

i do have a function that i use in the report to convert julian to mmddyyyy but i need to select on dates that are in the mmddyyyy format in the parameter prompt. the parameter dialogue will only point me to the database fields (in julian)



Rick Piekos
Massachusetts

 

[dgillz]

Make your parameter a static parameter, not a dynamic one, and make it a date datatype.

Then convert your julian field to a real date in a formula, and reference the formula in your record selection:

{?Date}={@YourFormula}

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[MegOBytes]

Thank you dgillz, that worked great.



RJ Piekos