infomania
Programmer
- Oct 27, 2002
- 148
I am using Crystal Reports (V9)to generate ad hoc reporting.
I would like the user to be able to input dates in the parameter selection.
How can I convert these to JDE format?
(ex. 1/2/2003==>103001)
Currently I use Pick lists which defines the equality but I have other situations where I would like to use CurrentDate as the default.
I can convert the other way:
(@InvDate: IF Left({sdivd},3)="103"
then ToText(DateValue({sdivd}-
65379),"MM/dd/yyyy"
else "Not a 2003 date"
I would like the user to be able to input dates in the parameter selection.
How can I convert these to JDE format?
(ex. 1/2/2003==>103001)
Currently I use Pick lists which defines the equality but I have other situations where I would like to use CurrentDate as the default.
I can convert the other way:
(@InvDate: IF Left({sdivd},3)="103"
then ToText(DateValue({sdivd}-
65379),"MM/dd/yyyy"
else "Not a 2003 date"