Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Date format

Hi Friends,

I have some dates entered in wrong  with wrong year in my data set as shown below

WrongCorrect
2/12/00202/12/2020
1/29/00201/29/2020
2/10/00202/10/2020
1/27/00201/27/2020
2/5/0020 2/5/2020

 

I want to change the year 0020 to 2020 in my all date fields while loading the data . Kindly help me with how to write the data load  script it please.

1 Solution

Accepted Solutions
Highlighted
Master
Master

Hi,

attached

Date(Date#(Wrong,'MM/DD/00YY'),'MM/DD/YYYY') as Correct

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

1 Reply
Highlighted
Master
Master

Hi,

attached

Date(Date#(Wrong,'MM/DD/00YY'),'MM/DD/YYYY') as Correct

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post