Skip to Content
0

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

Nov 08, 2017 at 05:14 PM

37

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Nov 08, 2017 at 09:41 PM
0

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


capture.jpg (79.0 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0
Former Member

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

0