0

Example:

I have a table name A and have three column name OVER_DUE_DATE_TIME(date/time), DUE_DATE_TIME(date/time) and DURATION(Integer, in hours).

I need to do this validation: DUE_DATE_TIME + DURATION <= OVER_DUE_DATE_TIME

If the validation is wrong then should prompt the user error message.

May I have this solution in C# !!


Thanks in advance !!

2
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by hwa
0

you can do this with retrieving the information from the SQL server:

DATEADD(dd, DURATION, DUE_DATE_TIME)

Taking into account that DURATION is the integer in the amount of days (7 for a week, 14 for two weeks, etc.)

Otherwise make sure that your DUE_DATE_TIME is a valid date, then set it to a variable and add the duration to it:

date DDT = DUE_DATE_TIME;
DDT = DDT.AddDays(parseInt(DURATION));

if (DDT > OVER_DUE_DATE_TIME)
{
response.write("book is overdue");
}

Again, taking into account that duration is an integer in the amount of days.

0

you can do this with retrieving the information from the SQL server:

DATEADD(dd, DURATION, DUE_DATE_TIME)

Taking into account that DURATION is the integer in the amount of days (7 for a week, 14 for two weeks, etc.)

Otherwise make sure that your DUE_DATE_TIME is a valid date, then set it to a variable and add the duration to it:

date DDT = DUE_DATE_TIME;
DDT = DDT.AddDays(parseInt(DURATION));

if (DDT > OVER_DUE_DATE_TIME)
{
response.write("book is overdue");
}

Again, taking into account that duration is an integer in the amount of days.

I want the Duration in Hours.

If the DUE_DATE_TIME(the time) + the DURATION is next day then the DUE_DATE_TIME should be increase one day and then compare to the OVER_DUE_DATE_TIME.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.