Date Diff Question

[campanellisj]

Morning all I have a small issue with two dates that I hope you can help with.

background:
need to have 2 date boxes formulate the following information. start date, end date, sum total number of days between them, display time remaining from current date...not to exceed 365

Status
I have a start date and and end date...I have all the expressions completed to populate the text boxes for days earned, days remaining from current date, but am unable to get the DB to display no more than 365 or to warn when it is over 365.

 

[raskew]

Hi -

Try playing with the following logic:

x = datediff("d", #12/28/08#, #1/3/10#)
? x
 371 

y = switch(x > 365, 365, true, x) 
? y
 365

HTH - Bob