Count Days

[Holm78]

Hi all


I have a textbox with a date ex. 2003-05-01
And in another textboxt I want a number for how many days has gone since that date to todays date. in this case
7 days.

Any code examples?

//Holm

 

[MrFancyteeth]

try the sys(11) function - julian day

?VAL(SYS(11,'08/05/2003'))-VAL(SYS(11,'01/05/2003'))

returns 7

btw - sorry about the british date format

MrF

 

[Mike Gagnon]

Holm78

Although MrFancyteeth's suggestion might work, a simple substraction between two dates gives you the result in days.

SET DATE MDY
SET CENTURY ON
Local date1,date2
store date() to date2
store ctod("05/15/2003")
nResult = date2-date1
? nResult && Gives 7

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[AirCon]

Try this:

- If your textbox is type of date
?date() - textbox.value

- If your textbox is type of character
?date() - ctod(textbox.value)

Regards

-- AirCon --

 

[AirCon]

Ahh..Mike, almost at the same time

Regards

-- AirCon --

 

[Holm78]

Thanks for the code.