Convert “General” data type to Date

Question

This might be a simple question, but I couldn't find a solution. I have an Excel Spreadsheet with a PostDate column whose value is: VLOOKUP(E2,upload!A:H,2,FALSE) and it shows as a Date. I'm using this spreadsheet as a data source, but my application (Sage MAS 500) sees the result of this calculation as a number, not a date and thus it fails to import the job. 
 For example, a PostDate in the spreadsheet shows 11/18/2013, but the preview data in the application shows 41596. 
 alaskasworld 
 Is there a formula that I can use in the cells to convert this value to a Date? I tried using DATEVALUE, but it didn't work.

David Speck · Answer

The function you need to use is TEXT. First argument is the value to format and the second argument is the format. You can refer to list of custom date formats to get an idea of what you can use. If you want it simple, just use "m/d/yyyy", this will produce a date string like 1/1/2021. If you use "mm/dd/yyyy", it will produce a date string like 01/01/2021.

Sage 100

Convert “General” data type to Date

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING