700
Hi All,
Is it possible to convert the value in time field to hours format, for comparison purpose?
For example, the user enters start time as x AM and end time as y AM/PM. Now, the difference between both should not be more than 12 hours. How to put this validation in AL code??
Please respond.
Thanks!
When I am entering 8 pm to 12 am, it is calculating a duration of -8 hours, thus not accepting
Actually we cannot change the requirement of the project. Is there any solution available ?
Now, 11 PM to 10 AM is also throwing error, but it should not
Thank You so much, Avinash. Need to ask about one more validation.
Such as, if start time is 11 PM (night) and end time is 12 PM (afternoon), then too system should show error. What should be the logic for this one ?
Hi
try this.
table 50117 "Standard Office Schedule"
{
DataClassification = ToBeClassified;
fields
{
field(1; "Code"; Code[50])
{
DataClassification = ToBeClassified;
}
field(2; "Scheduled Start Time"; Time)
{
DataClassification = ToBeClassified;
}
field(3; "Scheduled End Time"; Time)
{
DataClassification = ToBeClassified;
trigger OnValidate()
var
Duration: duration;
Hours: decimal;
begin
if "Scheduled End Time" > 0T then begin
Duration := "Scheduled End Time" - "Scheduled Start Time";
Hours := ((Duration / 1000) / 60) / 60;
if (Hours > 12) then begin
Error('Duration cannot be more than 12 hours');
end;
end;
end;
}
field(4; "Standard Lunch Break"; Integer)
{
DataClassification = ToBeClassified;
}
}
keys
{
key(PK; "Code")
{
Clustered = true;
}
}
var
myInt: Integer;
Hours: Decimal;
trigger OnInsert()
begin
end;
trigger OnModify()
begin
end;
trigger OnDelete()
begin
end;
trigger OnRename()
begin
end;
}
Regards
Avinash B
Please check if the below code is correct or not, to achieve the purpose !
table 50117 "Standard Office Schedule"
{
DataClassification = ToBeClassified;
fields
{
field(1; "Code"; Code[50])
{
DataClassification = ToBeClassified;
}
field(2; "Scheduled Start Time"; Time)
{
DataClassification = ToBeClassified;
}
field(3; "Scheduled End Time"; Time)
{
DataClassification = ToBeClassified;
trigger OnValidate()
var
myInt: Integer;
begin
if (Hours > 12) then begin
Error('Duration cannot be more than 12 hours');
end;
end;
}
field(4; "Standard Lunch Break"; Integer)
{
DataClassification = ToBeClassified;
}
field(5; "Duration"; Duration)
{
DataClassification = ToBeClassified;
trigger OnValidate()
var
myInt: Integer;
begin
Duration := "Scheduled End Time" - "Scheduled Start Time";
Hours := ((Duration / 1000) / 60) / 60;
end;
}
}
keys
{
key(PK; "Code")
{
Clustered = true;
}
}
var
myInt: Integer;
Hours: Decimal;
trigger OnInsert()
begin
end;
trigger OnModify()
begin
end;
trigger OnDelete()
begin
end;
trigger OnRename()
begin
end;
}
Share
Report
All responses (
Answers (
