ORDR table field "CreateTS" convert into time format crystal report

[nikunjmehta2290]

Dear all,

Convert the Sales order (ORDR) field "CreateTS" into time format like HH:MM:YY in crystal report.

Currently, These field is showing value like 112233. I need to set like 11:22:33 in this format via crystal report.

SAP Business One HANA

SAP Business One Crystal report

Kind regards,

Nikunj Mehta

[ido_millet]

Assuming {yourTime} is a number:

Picture(ToText({yourTime},0,""), "XX:XX:XX");

If it is a String, you can skip the conversion to text:

Picture({yourTime}, "XX:XX:XX");

[nikunjmehta2290]

Hi,

I am using Picture(ToText({yourTime},0,""), "XX:XX:XX");

Mu column is : Picture(ToText({ETL_PICKLIST_RPT.CreateTS},0,""), "HH:MM:SS");

While executing this above line then it is showing me error message like a boolean is required here.

Kind regards,

Nikunj Mehta

[ido_millet]

Use "XX:XX:XX"

[nikunjmehta2290]

Picture(ToText({UNE_PICKLIST_RPT.DocTime},0,""), "XX:XX:XX");

I am using above line and it is giving error like a boolean is required here.

[ido_millet]

What is the data type of your {UNE_PICKLIST_RPT.DocTime} column?

Are you entering this expression in a formula or in something that requires a boolean result (e.g. suppress condition, record selection)?

[nikunjmehta2290]

I am using Field DocTime from ORDR table.

In Crystal report, I was set these field but it is giving me output like 111111 instead of 11:11:11.

So, I have set the condition like Picture(ToText({UNE_PICKLIST_RPT.DocTime},0,""), "XX:XX:XX");

But it is not working.

Regards,

Nikunj Mehta