Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is there a built in function to calculate the sum of dates?

Status
Not open for further replies.

csiwa28

Programmer
Apr 12, 2001
177
I am able to add a day or several days to today's date and display it.

@Date(@Year(@Today);@Month(@Today);@Day(@Today + 1)

However, is there a built in function that will take into account if it is the last day of the month/year, or do I just have to come up with several if statments to do this?
 
Never mind, I found something.
 
Okay, for those that haven't figured it out and want to know, this would work...

@If(@Month(@Today) < @Month(@Adjust(@Today;0;0;1;0;0;0)); {true statement};{false statement})
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top