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 field: To_Date:
'1.10.2019' '12.10.2019'
' 13.10.2019' ' 26.10.2019'
How can i do?
Hi
Date
Date(Trim(SubField(Date,'to',1)),'DD.MM.YYYY') as From_Date field,
Date(Trim(SubField(Date,'to',2)),'DD.MM.YYYY') as To_Date field
Hope this helps
Thanks
Hi
Date
Date(Trim(SubField(Date,'to',1)),'DD.MM.YYYY') as From_Date field,
Date(Trim(SubField(Date,'to',2)),'DD.MM.YYYY') as To_Date field
Hope this helps
Thanks