Date in the excel is in dd-MMM-yyyy format but the select query is giving the it in wrong format like 44803.
Hi
Check whether the Excel file is in use or not while the DB action is carrying out. If yes, please close it and try again. Else, you can assign the Date to a String and then to a Date variable. From there, convert the format to the desired one through Date to String action and finally put it in your Insert query.
Hi
Try formatting the date in excel using vb script or python in input excel and then fetch it using excel as a database.
Date in the excel is in dd-MMM-yyyy format but the select query is giving the it in wrong format like 44803.
It’s easier change the Excel datatype column in the spreadsheet to Custom format.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.