Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Creator III
Creator III

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
Creator III
Creator III
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