How to format a date pulled from another workbook

[phillipc1]

Hello,

I am working on a solution to pull a date from one workbook to another, but I would like the format to change via the formula I am using. What formula can I use to achieve this?

Source date format example:
Apr 13, 2022, 11:40:54 AM

Destination date format example:
4/13/2023

This is the formula I am currently using, and I have the iferror added into it as I want this formula to match essentially all values (dates) in column "G" of the source workbook to column "D" of this new workbook. In the event there is no data, it leaves the field blank. If anyone also has an easier way to go about that, I would appreciate it.

=IFERROR('2023-11-08_Devices_Lytx.csv'!$G2,"")

Destination Workbook:

Source Workbook:

 

[Joe4]

Try this:

=IFERROR(TEXT('2023-11-08_Devices_Lytx.csv'!$G2,"m/d/yyyy"),"")

 

[phillipc1]

Hi Joe,

As soon as I read your response it clicked. I forgot about that route. However, it looks like I am still encountering the same issue. Perhaps a little more insight into this process may help.

The source workbook is a csv report pulled from a vendor's site and as such the field we have as our date is in a "General" format. The goal is that we can pull this report daily and save it over the existing file which will then feed into our destination workbook. The data in our destination workbook is used to run different pivot tables and analysis in conjunction with other data we have.

 

[Joe4]

Can you tell me what this formula returns if you enter it into any empty cell?

=ISNUMBER('2023-11-08_Devices_Lytx.csv'!$G2)

If that returns FALSE, it means the entry in a text one, in which case, try this formula:

=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('2023-11-08_Devices_Lytx.csv'!$G2,",",2)),"m/d/yyyy"),"")

 

[phillipc1]

That did it! The entry was returning as false so I utilized the second formula provided which did the trick. Thank you so much!

 

[Joe4]

You are welcome!
Glad I was able to help!