[SOLVED] NOW() not working so good...

[hzman]

Hi, I have this macro assigned for a button:

[code]

sub ButtonPressed (oEv as object)
dim oForm as object
dim oField as object
dim idate as long
idate=now() -2
oForm = oEv.source.model.parent
oField=oForm.GetByName("datSaapumispvm")
oField.BoundField.value=idate
end sub
[/code]

Date I get from this is two days ahead... so with (-2) I get the right date for the datSaapumispvm. TODAY gives me 1.1.1900, and DATE gives also two days ahead...

Any idea why it is so?? Computer time is right, Windows 7, OpenOffice 3.3.0.

Thanks, Hermanni

[RPG]

Hello

Maybe this
http://www.oooforum.org/forum/viewtopic.phtml?t=82385&postdays=0&postorder=asc&highlight=sub+date&start=0
can help you.

There you can find different kind of solutions.

Romke

[hzman]

Hi, thanks for the link, but none that I have tried helps.

If I use idate as STRING then the value of the idate includes "-marks ("11.1.2012"), and it gives me a date 01.01.1800 to datSaapumispvm field. If I use idate as LONG then the value is 11 (today) and it gives me a result of 12.01.1900...

NOW() function gives me a result of 40920 (when idate is LONG), which ends up being 14.1.2012 in datSaapumispvm field, so at the moment 3 days ahead... ????

I have msgbox(idate) in my code so I can see what the idate is before it goes to datSaapumispvm.

Hermanni

[RPG]

Hello

If none of them work I don't have any idea what is wrong.

Romke

[RPG]

Hello

I think you add a value to a date field and it can be better to add a string to the date field. I have learned from Villeroy that there is a different between numbering in date between OOo and what is used in SQL.


Romke

[dacm]

See also:
Now() conversions
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Migrating 'Embedded databases'

[RPG]

Hello

I did place a more clear explanation in the thread.

Romke

[dacm]

[hzman]

I had no idea that you can have a dropdown calender for date-field in a form.

But that does the trick for me. Thanks everyone for good try, none of them worked for me though, or I just didn't know how to make these examples to work.

Hermanni