Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Naresh1
Contributor III
Contributor III

Splitting dates from date field

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?

1 Solution

Accepted Solutions
Kashyap_R
Partner - Specialist
Partner - Specialist

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

 

Thanks and Regards
Kashyap.R

View solution in original post

2 Replies
Kashyap_R
Partner - Specialist
Partner - Specialist

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

 

Thanks and Regards
Kashyap.R
BinayKumarSah
Contributor III
Contributor III

Date(Trim(SubField(Date,'to',1)),'DD/MM/YYYY') as From_Date_colm,
Date(Trim(SubField(Date,'to',2)),'DD/MM/YYYY') as To_Date_colm