Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
srini
Creator
Creator

Date(Date#(TextBetween(FileBaseName(),'(',')'),'MM/DD/YYYY')) AS Week .... not working!

Hi Friends,

Date(Date#(TextBetween(FileBaseName(),'(',')'),'MM/DD/YYYY')) AS Week, 

 

I have used this to get my file name as new datafield(in date format) but it is not working. 😞

the file name is 

RBWM Tech Overdue GMT Training (01-Jan-2019)

1 Solution

Accepted Solutions
sunny_talwar

Try this

Date(Date#(TextBetween(FileBaseName(),'(',')'), 'DD-MMM-YYYY'), 'MM/DD/YYYY') as Week, 

View solution in original post

1 Reply
sunny_talwar

Try this

Date(Date#(TextBetween(FileBaseName(),'(',')'), 'DD-MMM-YYYY'), 'MM/DD/YYYY') as Week, 

View solution in original post