KB20710: How to convert data stored in Julian Date format to regular date in an attribute form in MicroStrategy Developer

In certain situations, dates are stored in Julian Date format in the data warehouse. Follow the next steps in Strategy Developer convert from Julian Date to regular date format in an attribute definition.
 
Follow the next steps to create an attribute form to convert the Julian Dates to standard date format
 

• Edit the Julian Date attribute and create a new attribute form
• Define the new attribute form using an apply simple statement as shown below
  

•  
  ApplySimple("DateSerial(1900+(#0\1000),1,#0 Mod 1000)", )
  
• Under Form format, select 'Date' as shown in the image below
  

• From the Column Alias tab, modify the column alias of the attribute form to reflect the expected date format.
  

• Create a report displaying both attribute forms to compare the outputs.
  

NOTE:
The ApplySimple statements given above are ACCESS specific. The same logic should apply for other databases, but the syntax will need to be changed.