How to format a julian date to std date in SQL Query

[RunTime91]

Greetings...

I hope this is the correct place to post this...

When I run the following code (DoCmd.TransferSpreadsheet acImport...) to update a table with values pulled from an excel file in puts the dates in Julian date format

Thus

1/2/2018 is uploaded as 43102
1/3/2018 is uploaded as 43103

These values are eventually called from another query by date but that query is using date: CDate([FieldName]) with a criteria of: >Date() to extract the dates requested



However because the dates are in the 43102, 43103, format it recognizes no dates at all and thus pulls no data.

When I format the field in the table to Date/Time - ShortDate and run the query again it imports the date header but no dates.

I've tried using CONVERT - No luck,

I'm not sure if I should try to format the date before or during the import from Excel or after it imports the julian dates and before the next query.

Below is the SQL Query to take the imported data and move certain dates to another table

SELECT CDate([F1]) AS [date], CInt([F2]) AS RefCRttl, CInt([F5]) AS RefCR2day, CInt([F7]) AS RefCR3day
FROM tmpRefWTDCR
WHERE (((CDate([F1]))<Date()) AND ((IsDate([F1]))=-1));

I hope I have provided enough information to assist...Thank You

[ArviLaanemets]

Try

SELECT (DATESERIAL(1900,1,0) + [F1]) AS [date], ...

[RunTime91]

Brilliant!... Works great, Arvil...Sorry for the late response of gratitude... was away for awhile...

Thanks again, Arvil