EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics
  3. KB41443: "The end date may not be before the start date." Error returned when executing data load with MicroStrategy Command Manager 2020 and above

KB41443: "The end date may not be before the start date." Error returned when executing data load with MicroStrategy Command Manager 2020 and above


Community Admin

• Strategy


This article explains why "The end date may not be before the start date. Please enter a valid start/end date." Error appears even when the end date is actually after the start date and suggests a resolution.

SYMPTOM
After executing a command to run Custom Time Window for a data load, an error message returned. For example, the following command is executed:EXECUTE DATA LOAD "Test" WITH DATA FROM "7/22/2010 22:00:00 +0000" TO "8/01/2020 23:00:00 +0000" IN ENTERPRISE MANAGER "localhost" IN PORT 9999;
MicroStrategy Command Manager returned an error:
The end date may not be before the start date. Please enter a valid start/end date.

rtaImage (8).png

However, as shown in the sample command, the end date is not before the start date. 
CAUSE
End date for Custom Time Window option for Enterprise Manager Data Load cannot be a future date. When this command is executed, it was not yet August 1st, 2020. This error message appears even when you are just one hour ahead of the time you execute the command.
ACTION
Edit the end date to be a past date, then, execute the command again. 
For more information about how to compose commands for Enterprise Manager data load, refer to Guideline_EM.pdf file attached to the following article:
KB273206: Best practices for configuration of MicroStrategy Enterprise Manager 10.x
KB441443


Comment

0 comments

Details

Knowledge Article

Published:

January 31, 2024

Last Updated:

January 22, 2026