how can i display an input date as my report date in crystal report

[former_member529017]

Hello

I have report that has some prompt variables. In that one variable is from date. Whatever the date i enter in the prompt that value it should appear in the top right corner of my crystal report 2016 version. Can anybody tell me how to do this?

Any System defined field?

[former_member182342]

Hi Paturi,

Just drag and drop the date parameter which you require in the report layout from parameter tab as shown in the below image.

capture.jpg

If you require any more information. Please go to below link:

https://www.tutorialspoint.com/crystal_reports/crystal_reports_parameters.htm

Regards,

Anish

[former_member529017]

Hello Anish,

Thank you for the Reply. I tried with the below logic. But it gives me the format of DD/MM/YYYY

ToText(DateSerial(ToNumber(Left(ToText({?psHana Variable IP_FROMDATE}),4)),

ToNumber(Mid (ToText({?psHana Variable IP_FROMDATE}), 5, 2)),

ToNumber(Right(ToText({?psHana Variable IP_FROMDATE}),2))),"dd/MM/yyyy")-- If i give the format here as yyyy/mm/dd its showing me the error. if i dont give number 5 in the second line that also not working.

Can you please suggest me with the correction ?

Thanks

Paturi

[former_member182342]

Hi Paturi,

Please try below formula and do let me know if it working or not.

ToText(CDate({TableName.FieldName}), "yyyy/mm/dd")

Regards,

Anish