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

[srini]

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)

[sunny_talwar · Accepted solution]

Try this

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