Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Specialist
Specialist

SET DateFormat = 'YYYY/MM/DD'; not working

Hi experts

This date format is not working: SET DateFormat = 'YYYY/MM/DD';

It finally shows as result DD.MM.YYYY

Any ideas how to fix this wrong behaviour?

 

Thanks

Tom

Labels (1)
2 Replies
TomBond77
Specialist
Specialist
Author

Connector used: QvSAPBExConnector

jonathandienst
Partner - Champion III
Partner - Champion III

The Dateformat variable defines the default date format used by Date(), Date#() and other date returning functions. It does not control the date format of fields read from a data source. If the dates returned by the QvSAPBExConnector are valid numerical date types (they will right-align in  list box), then convert them to the default  format using Date(fieldname).

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein