SAP Knowledge Base Article - Preview

2194686 - How to display Date and Time columns using the Windows Regional Settings – SAP PB


  • To display a date, datetime or time column in a DataWindow, we use the properties editMask and format.
  • For example: If you set the French format "dd/MM/yyyy" for a date or datetime column, it will display 25/07/2015.  
  • In this case, the format is "hard-coded". If the application is deployed on a US machine, you will get the French format and not the US format which is MM/dd/yyyy.
  • The same problem can happen with time columns: some countries are using 24hours time, others, like US, use 12hours format (ex. 06:30 PM).



SAP PowerBuilder (PB) 12.5.2 on supported Windows Operating Systems.


SAP PowerBuilder 12.5


longdate, datetime, datawindow, format, mask, date, time , KBA , BC-SYB-PB , PowerBuilder , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.