Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to convert the following format:
Date : Sep 2017 to 08-2017
Any suggestions please?
Regards
maybe you have to ltrim some spaces
hi,
try this on the script:
num(month(date#(left(Date,3),'MMM')))&'-'&right(Date,4) as Date
Nice one Youssef, its picking the 2017 field but not picking the month field.
Extract is looking like : -2017 (Month is not picked)
Regards
Hi Rudra,
Maybe this will work
Date(Date#('Sep 2017','MMM YYYY'),'MM-YYYY')
Regards,
Bhargav
Hi Bhargav, tried that one, but its not working.
Regards
Hi Rudra,
Sep 2017 is in Date format or text format
Regards,
Bhargav
Bhargav , its in Text Format
Regards
Hi Rudra,
The above expression should work .Can you please share Sample data if possible
Regards,
Bhargav
You can also try this expression if above expression does'nt work
Pick(Match(Left(FieldName,3),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')
,01,02,03,04,05,06,07,08,09,10,11,12) & '-' & right(FieldName,4)
Hi Bhargav, i can explain the scenario:
* I got no date field in source data.
* I picked the date part from source data excel file names(File name has extension -sep 2017.xls )
* Used text between to extract that part (Sep 2017)
* Now i am trying to convert that Sep 2017 field value to 08-2017 to mark it as date field in all the excel source files.
Regards