|
View previous topic :: View next topic
|
| Author |
Message |
Digvijay Singh
Active User
Joined: 20 Apr 2022
Posts: 148
Location: India
|
|
|
|
Hello Everyone,
Need bit help in sorting here requirement is I have two file1 and File2.
File1, has date at column 67 to 75 date format is below.
24-JUL-24
dd-mm-yy: last two number of year 24 here which is 2024
File2 has date at column 1 to 8 date format is below.
20240901
yyyy-mm-dd
I want to compare these two file whether the dates are matching or not. I am facing issue in converting the JUL to 07 means converting this to number of month value. could anyone help me here or give me any hint on these sort steps. |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10884
Location: italy
|
|
| Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1329
Location: Bamberg, Germany
|
|
|
|
Excuse me, but this is not true.
| Quote: |
File2 has date at column 1 to 8 date format is below.
20240901
yyyy-mm-dd |
To convert the Date, see either CHANGE or FINDREP operators. I would prefer CHANGE for this task. |
|
| Back to top |
|
|
|
|
