Forum

Notifications
Clear all

Matching dates to all the data in the column

4 Posts
2 Users
0 Reactions
152 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 
Hi, thanks for the help with the attachment -
Column B has dates of 2 types - one in Hebrew format and one in English format

How do you change the English format to the Hebrew format? Will there be a match with the data in column C??
 
Posted : 31/10/2022 10:02 am
Riny van Eekelen
(@riny)
Posts: 1196
Member Moderator
 

I imported to the CSV file (legacy text wizard) and indicated that the second column contained dates in the MDY format and the third in the DMY format. That transformed both columns into valid dates as seen in the attached files.

Important that you don't just open the CSV file in Excel. Then Excel will do some guessing as to how to interpret texts that look like dates. 

Is that what you had in mind?

 
Posted : 01/11/2022 2:02 am
(@usb)
Posts: 244
Honorable Member
Topic starter
 

Hi,
I would love to understand why you set the second column to MDY?
After all, the Israeli pattern is - DMY

 
Posted : 02/11/2022 2:40 pm
Riny van Eekelen
(@riny)
Posts: 1196
Member Moderator
 

The MDY or DMY setting depends on how the source data looks like. Then Excel knows how to "translate" that to your local date format. Since the dates in the second column look like mm/dd/yyyy you need to use MDY upon import and it will come out as dd/mm/yyyy.

 
Posted : 03/11/2022 1:39 am
Share: