Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-10-19 12:26 AM

Date Format

Hi

I am extracting data from SAP BW and I have a date field having the format DD.MM.YYYY.  I want to change it to MM/DD/YYYY. I have tried using the function below but it's not returning any value. I have also tried changing the DateFormat in the script but to no avail.

date#((Date([Posting date - Posting date Level 01 (Text)],'DD.MM.YYYY')),'MM/DD/YYYY')  as [Posting Date]

qv1.PNG

1,275 Views
0 Likes
11 Replies
Anonymous
Not applicable
‎2016-10-19 10:28 AM
Author

Thanks All! 

173 Views
0 Likes
Anonymous
Not applicable
‎2016-10-19 10:29 AM
Author

In response to tresesco

Thank you!

173 Views
0 Likes