Date field (Access database)
Quote from nikyred on March 23, 2023, 5:09 pmHi,
I'm creating an application that connects to an access database.
When I have to write the date on a database field I have no problems.
When I use the "SetVar" function, because I want to copy a date from a field of a table to a field of another table, it doesn't write the date correctly.this is the date: 23/03/2023
this is what he writes me: 0,00378975119459548525why do i have this problem?
Thank you
Hi,
I'm creating an application that connects to an access database.
When I have to write the date on a database field I have no problems.
When I use the "SetVar" function, because I want to copy a date from a field of a table to a field of another table, it doesn't write the date correctly.
this is the date: 23/03/2023
this is what he writes me: 0,00378975119459548525
why do i have this problem?
Thank you
Quote from luishp on March 23, 2023, 10:42 pm@nikyred note that if you use something like this:
SetVar "[myvar]" "23/03/2023"VisualNEO Win will do the math operation and assign the result to [myvar] (0.00378975119459548525)
But if you use this (using an exclamation sign), the data will be assigned as it is, as a string, without doing any math:
SetVar "[myvar]" "!23/03/2023"So [myvar] will store "23/03/2023" instead of 0.00378975119459548525
Regards.
@nikyred note that if you use something like this:
SetVar "[myvar]" "23/03/2023"
VisualNEO Win will do the math operation and assign the result to [myvar] (0.00378975119459548525)
But if you use this (using an exclamation sign), the data will be assigned as it is, as a string, without doing any math:
SetVar "[myvar]" "!23/03/2023"
So [myvar] will store "23/03/2023" instead of 0.00378975119459548525
Regards.