Hi I have two field StartDate and EndDate which are of type DATETIME in my Customization project. Now want to add the codindtion in which start date and end date are independent on each other.
Conditions are :-- Cond 1 → EndDate > Start Date → If the Start Date is selected first
Cond 2 → Start Date < End Date → If the End Date is selected first
My DAC fields are the below fields
#region StartDate [PXDBDate()] [PXUIField(DisplayName = "Start Date")] public virtual DateTime? StartDate { get; set; } public abstract class startDate : PX.Data.BQL.BqlDateTime.Field<startDate> { } #endregion
#region EndDate [PXDBDate()] [PXUIField(DisplayName = "End Date")] public virtual DateTime? EndDate { get; set; } public abstract class endDate : PX.Data.BQL.BqlDateTime.Field<endDate> { } #endregion
Use a FieldVerifying event in your graph extension to ensure EndDate is always greater than StartDate when either field is changed
Try below sample code
publicclass YourGraphExtension : PXGraphExtension<YourGraph>
{
protectedvoid _(Events.FieldVerifying<YourDAC.startDate> e)
{
var row = (YourDAC)e.Row;
if (row == null || e.NewValue == null) return;
DateTime? newStartDate = (DateTime?)e.NewValue;
// Condition 1: If EndDate is already selected, StartDate must be less than EndDateif (row.EndDate != null && newStartDate >= row.EndDate)
{
thrownew PXSetPropertyException("Start Date must be earlier than End Date.");
}
}
protectedvoid _(Events.FieldVerifying<YourDAC.endDate> e)
{
var row = (YourDAC)e.Row;
if (row == null || e.NewValue == null) return;
DateTime? newEndDate = (DateTime?)e.NewValue;
// Condition 2: If StartDate is already selected, EndDate must be greater than StartDateif (row.StartDate != null && newEndDate <= row.StartDate)
{
thrownew PXSetPropertyException("End Date must be later than Start Date.");
}
}
}
Use a FieldVerifying event in your graph extension to ensure EndDate is always greater than StartDate when either field is changed
Try below sample code
publicclass YourGraphExtension : PXGraphExtension<YourGraph>
{
protectedvoid _(Events.FieldVerifying<YourDAC.startDate> e)
{
var row = (YourDAC)e.Row;
if (row == null || e.NewValue == null) return;
DateTime? newStartDate = (DateTime?)e.NewValue;
// Condition 1: If EndDate is already selected, StartDate must be less than EndDateif (row.EndDate != null && newStartDate >= row.EndDate)
{
thrownew PXSetPropertyException("Start Date must be earlier than End Date.");
}
}
protectedvoid _(Events.FieldVerifying<YourDAC.endDate> e)
{
var row = (YourDAC)e.Row;
if (row == null || e.NewValue == null) return;
DateTime? newEndDate = (DateTime?)e.NewValue;
// Condition 2: If StartDate is already selected, EndDate must be greater than StartDateif (row.StartDate != null && newEndDate <= row.StartDate)
{
thrownew PXSetPropertyException("End Date must be later than Start Date.");
}
}
}
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
