Hello everyone!
I have DateTime field in my query.
I am fromatting it to a dd/mm/yyyy in Crystal.
Ths field is a parameter.
I need to set it up so it shows current date on first pop up.
I am setting default as 9/9/9999.
I am inserting parameted {?CurrentDate}.
In Selection Formula I insert {t.field}>{?CurrentDate}
Report runs fine. Except sometimes I am getting third party software error message that 'Default parameter 9/9/9999 is invalid' I can click this message out and continue to run Report successfully but it doesn't look good for the users.
I am thinking maybe there is a better way dealing with DateTime datatype or better set up then 9/9/9999?
Please, advise.
Thanks
I have DateTime field in my query.
I am fromatting it to a dd/mm/yyyy in Crystal.
Ths field is a parameter.
I need to set it up so it shows current date on first pop up.
I am setting default as 9/9/9999.
I am inserting parameted {?CurrentDate}.
In Selection Formula I insert {t.field}>{?CurrentDate}
Report runs fine. Except sometimes I am getting third party software error message that 'Default parameter 9/9/9999 is invalid' I can click this message out and continue to run Report successfully but it doesn't look good for the users.
I am thinking maybe there is a better way dealing with DateTime datatype or better set up then 9/9/9999?
Please, advise.
Thanks