Field name is "date" now I can't use "Date()" Function 1

[dontay]

Hi all,
In one of my first apps I named the date field "date".(I will never do that again).
Now when I try to use the "Date()" Function to update another text box, it adds what ever date is in the date field and not the current date.
How can I use the "Date()" function to produce the current date?
Thanks ahead of time.
Don

 

[psemianonymous]

crossposted thread705-794505

 

[TheAceMan1]

How are ya dontay . . . .

If you want the current date, I don't understand why you don't use the well known Now() function?

TheAceMan

 

[BNPMike]

Now() will give you a timestamp but you can limit that to just the data using properties.

 

[TheAceMan1]

Hay BNPMike . . . How are ya!

The Integer portion of Now() is the date part. The Decimal portion is the time part. So Int(Now()) returns the date only!

TheAceMan

 

[dontay]

Thanks All,
Int(Now()) solves the problem.