Changing of Time Format

[Former Member]

Dear Experts,

Good day!

I am currently incorporating the creation time in a Purchase Order form. I am using OWDD table in SAP. But upon previewing the report, the time format is 935 instead of 09:35AM. Can someone help me how to make the format right?

Thanks!

Ashley

[former_member188586 · Accepted solution]

hi

can check once bellow link and update the status

General Settings: Display Tab - SAP Business One 8.82 - SAP Library

Thanks& RegardsAndakondaramudu

[Former Member · Accepted solution]

Hi AndakondaRamudu,

Thank you for your response but I'm not talking about format inside SAP. I'm talking about the time format in crystal report file.

Regards,

Ashley

[former_member188586 · Accepted solution]

ok fine

check bellow thread and update the status

[former_member188586 · Accepted solution]

HI check bellow thread

for discussion about you problem but solution gives above thread

[former_member212181]

Hi Leigh Ashley,

Which tool you are using for PO design?

In standard PLD, it is correctly showing as 9.35 AM/ PM.

If you are not using standard B1 PLD, then use formulae to get it done.

First Calculate the length of the field,

then convert to required format as per length.

Thanks

Unnikrishnan

[Former Member]

Hi Unnikrishnan,

I am using crystal report for sap business one.

Thanks!

Ashley

[former_member212181]

Hi Ashley,

If that is the case, please check field properties in crystal report for that field.

If it doesn't works, then create formulae as I mentioned earlier post.

Thanks

Unnikrishnan

[former_member188586]

hi check bellow Image then you may understand clearly