topic Re: Adding dates from columns in Discussions

Adding dates from columns

UserID16644 — Tue, 10 Oct 2023 23:25:48 GMT

I have 3 dates that I wanted to add up in order to calculate the total number of days. Is there a way to do this? I just know the Date Difference ( ) function, but doesn't know if there is a function used in calculating the sum of dates from three different columns?

Re: Adding dates from columns

Jeff_Perkinson — Tue, 10 Oct 2023 23:57:33 GMT

Adding dates is an interesting concept.

Can you explain exactly what you mean?

I’m trying to guess what April 3, 2022 + May 22, 2022 would be.

Re: Adding dates from columns

UserID16644 — Wed, 11 Oct 2023 00:00:27 GMT

Yes, so the sum would be how many days does April 3-May 22 have

Re: Adding dates from columns

txnelson — Wed, 11 Oct 2023 01:14:56 GMT

Here is a simple example:

Names Default To Here( 1 );
date1 = informat("4/3/2023");
date2 = informat("5/22/2023");
Date Difference(
	Date1,
	Date2,
	"Day",
	"start"
);

Re: Adding dates from columns

Jeff_Perkinson — Wed, 11 Oct 2023 01:19:12 GMT

That helps. The Date Difference() function will tell you the number of days between two dates.

//:*/
start = 03Apr2022;
end = 22May2022;
days = Date Difference( start, end, "Day" );
/*:

49

You said something about a third date. How will that be used?

For more information you might find useful.