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 ONE Support launchpad (Login required).

Search for additional results

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