Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey everyone,
I have some datas (from a particular colomn) that are showed like this in my source: 20131022 ****** Projects, Operations and maintenance quarterly review
I would like to extract and transform the 8 first numbers in a date.
In my example: 20131022 will be extracted and transformed in the date 22/10/2013.
I dont know how to do this in the script for this particular colomn called "List Name".
Thanks in advance,
best regards,
Arnaud
date(date#(left([List Name],8),'YYYYMMDD'),'DD/MM/YYYY')
date(date#(left([List Name],8),'YYYYMMDD'),'DD/MM/YYYY')
Hi Arnaud,
You should use a expression like this
date(left([List Name], 8), 'YYYYMMDD') as [List Name]
To begin with you can use for example left(FieldName,8) to get the 8 carachers you need.
Then you can wrap a date# function around it to format the date
Date#(left(YourFieldName,8),'YYYYMMDD') as Date,