Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have Date Field in that field having values like '1.10.2019 to 12.10.2019'
' 13.10.2019 to 26.10.2019'
i want to split this values into two fields,
From_Date : To_Date:
'1.10.2019' '12.10.2019'
' 13.10.2019' ' 26.10.2019'
How can i do?
Maye be :
Data:
load Date#(trim(left(DateField,index(DateField,'to')-1)),'DD.MM.YYYY') as From_Date ,Date#(trim(right(DateField,index(DateField,'to')-1)),'DD.MM.YYYY') as To_Date,* inline [
DateField
1.10.2019 to 12.10.2019
13.10.2019 to 26.10.2019
];
Maye be :
Data:
load Date#(trim(left(DateField,index(DateField,'to')-1)),'DD.MM.YYYY') as From_Date ,Date#(trim(right(DateField,index(DateField,'to')-1)),'DD.MM.YYYY') as To_Date,* inline [
DateField
1.10.2019 to 12.10.2019
13.10.2019 to 26.10.2019
];