Compare two dates from table Dynamics

Sv1N2S · 2017-10-20

I'm having problem with my little task. I have a table with information about two users who are working during this time. If this time intersect I need get a MESSAGE/ERROR about it. Can you explain how to do this? Thanks!!

pleachim@outlook.com · 2017-10-20

Juhl wrote: »

Use 2 Date records (virtual table).
Do a setrange on both with data from each user, if the both return NOT ISEMPTY you have your error.

Please give us the code. I don't get this sorry.

Those things can drive me crazy. But I like such competitions.
I have a quite complicated way. BUT there MUST be an easier way.

TestUserEntry.RESET;
TestUserEntry.SETFILTER("Entry No.",'<>%1',"Entry No.");
TestUserEntry.SETRANGE(UserID,UserID);
TestUserEntry.SETFILTER("Starting Date",'<=%1',"Starting Date");
TestUserEntry.SETFILTER("Ending Date",'>=%1',"Starting Date");
IF TestUserEntry.FINDFIRST THEN
  ERROR('Starting Date not correct. Existing Entry %1',TestUserEntry."Entry No.");

TestUserEntry.SETFILTER("Starting Date",'>=%1',"Starting Date");
TestUserEntry.SETFILTER("Ending Date",'<=%1',"Starting Date");
IF TestUserEntry.FINDFIRST THEN
  ERROR('Starting Date not correct. Existing Entry %1',TestUserEntry."Entry No.");

TestUserEntry.SETFILTER("Starting Date",'>=%1',"Ending Date");
TestUserEntry.SETFILTER("Ending Date",'<=%1',"Ending Date");
IF TestUserEntry.FINDFIRST THEN
  ERROR('Ending Date not correct. Existing Entry %1',TestUserEntry."Entry No.");

TestUserEntry.SETFILTER("Starting Date",'<=%1',"Ending Date");
TestUserEntry.SETFILTER("Ending Date",'>=%1',"Ending Date");
IF TestUserEntry.FINDFIRST THEN
  ERROR('Ending Date not correct. Existing Entry %1',TestUserEntry."Entry No.");

Juhl · 2017-10-20

Use 2 Date records (virtual table).
Do a setrange on both with data from each user, if the both return NOT ISEMPTY you have your error.

pleachim@outlook.com · 2017-10-20

Juhl wrote: »

Use 2 Date records (virtual table).
Do a setrange on both with data from each user, if the both return NOT ISEMPTY you have your error.

Please give us the code. I don't get this sorry.

Those things can drive me crazy. But I like such competitions.
I have a quite complicated way. BUT there MUST be an easier way.

TestUserEntry.RESET;
TestUserEntry.SETFILTER("Entry No.",'<>%1',"Entry No.");
TestUserEntry.SETRANGE(UserID,UserID);
TestUserEntry.SETFILTER("Starting Date",'<=%1',"Starting Date");
TestUserEntry.SETFILTER("Ending Date",'>=%1',"Starting Date");
IF TestUserEntry.FINDFIRST THEN
  ERROR('Starting Date not correct. Existing Entry %1',TestUserEntry."Entry No.");

TestUserEntry.SETFILTER("Starting Date",'>=%1',"Starting Date");
TestUserEntry.SETFILTER("Ending Date",'<=%1',"Starting Date");
IF TestUserEntry.FINDFIRST THEN
  ERROR('Starting Date not correct. Existing Entry %1',TestUserEntry."Entry No.");

TestUserEntry.SETFILTER("Starting Date",'>=%1',"Ending Date");
TestUserEntry.SETFILTER("Ending Date",'<=%1',"Ending Date");
IF TestUserEntry.FINDFIRST THEN
  ERROR('Ending Date not correct. Existing Entry %1',TestUserEntry."Entry No.");

TestUserEntry.SETFILTER("Starting Date",'<=%1',"Ending Date");
TestUserEntry.SETFILTER("Ending Date",'>=%1',"Ending Date");
IF TestUserEntry.FINDFIRST THEN
  ERROR('Ending Date not correct. Existing Entry %1',TestUserEntry."Entry No.");

AK · 2017-10-20

I don't know if I get the task, but if Name, Date Start and Date Finish are the primary key of that table, the error will occur automatically when the same user will have the same start and end date twice.

pleachim@outlook.com · 2017-10-20

just imagine you can not post a date twice AND you can not have a starting date between another timespan. Then you have to do a check like mine above

Sv1N2S · 2017-10-23

thanks for helping

Compare two dates from table Dynamics

Best Answer

Answers

Categories