another one of my famous questions
lazarus / 10-Designer

----------------------------------------------------------------------
cazzajay · 2009-08-16 22:10

how do i get the number of days since 1/1/1900 like in excel?

i.e. 04/01/1900 would be '4' and 01/02/1901 would be '397'?  ideally
output as an integer

i guess its something like

strtoint(formatdatetime('dddddddddddd', now-01/01/1900))

or similar.... ???

----------------------------------------------------------------------
cazzajay · 2009-08-16 22:20

incidentally, i believe there was a command back in delphi called
DaysBetween as in:

inttostr(DaysBetween(date1, date2))

which woulda sufficed perfectly, but that doesnt seem to work in
lazarus???

----------------------------------------------------------------------
theo · 2009-08-16 22:28

Quote from: cazzajay on August 17, 2009, 12:20:02 ambut that doesnt
seem to work in lazarus???

Why do you think it doesn't work?

----------------------------------------------------------------------
cazzajay · 2009-08-16 22:32

command has changed to something else?

----------------------------------------------------------------------
theo · 2009-08-16 22:34

Quote from: cazzajay on August 17, 2009, 12:32:36 amcommand has
changed to something else?

No, why?

----------------------------------------------------------------------
cazzajay · 2009-08-16 22:36

is there some uses thingy i need to add to the top of the page?

----------------------------------------------------------------------
theo · 2009-08-16 22:39

Quote from: cazzajay on August 17, 2009, 12:36:14 amis there some uses
thingy i need to add to the top of the page?

Yes.

----------------------------------------------------------------------
cazzajay · 2009-08-16 22:40

yay im getting better clevering y'all    would you honour me by
elucidating which 'uses'?

----------------------------------------------------------------------
theo · 2009-08-16 22:54

Hmm, you could type "delphi daysbetween" in the Google-Search and
follow the first link.
Or you could use "Find in files" in the Lazarus IDE or ....
Since you remember the function name from the delphi days, it should
be easy.
It's in the same unit as in delphi btw.

----------------------------------------------------------------------
cazzajay · 2009-08-16 22:58

i have it now, from website delphi basics - DateUtils!!! 

thanks for the guidance - i feel much the wiser...

PS i was programming in delphi from age 14 to age 17.  i am now 24. 
i'm a bit rusty plus i have never studied computing in academia (i did
my degree in economics :S)

----------------------------------------------------------------------
theo · 2009-08-16 23:08

Quote from: cazzajay on August 17, 2009, 12:58:36 amthanks for the
guidance - i feel much the wiser...

You are welcome!

----------------------------------------------------------------------
rocotilos · 2009-09-05 19:01

If u already know the function name, google will have all the answer.