Hi,

What is the best way to convert return value of Now() function to pure Date
(21.062006. 15:30 => 21.06.2006.)??


Thanks!
Domagoj

Format(Now(),dd.mm.yyyy)

--
hth,
SusanV


"Domac" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi,
>
> What is the best way to convert return value of Now() function to pure
> Date (21.062006. 15:30 => 21.06.2006.)??
>
>
> Thanks!
> Domagoj
>

Hi, Domac.

> What is the best way to convert return value of Now() function to pure
> Date

Instead of converting the value returned from the Now( ) function, you'd use
the Date( ) function in your code. However, if you want to convert a
Date/Time value that has already been stored in the table by using the
Now( ) function, then use the DateValue( ) function. For example:

SELECT IIF(ISNULL(SomeDate), NULL, DateValue(SomeDate)) AS TheDate
FROM tblStuff;

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"Domac" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi,
>
> What is the best way to convert return value of Now() function to pure
> Date (21.062006. 15:30 => 21.06.2006.)??
>
>
> Thanks!
> Domagoj
>

I usually use Int(Now). Using Int() truncates the date to just date, no time
stamp.


"Domac" wrote:

> Hi,
>
> What is the best way to convert return value of Now() function to pure Date
> (21.062006. 15:30 => 21.06.2006.)??
>
>
> Thanks!
> Domagoj
>
>
>

DateValue is preferred to Int (Int doesn't work properly for dates prior to
30 Dec, 1899)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Linc" <(E-Mail Removed)> wrote in message
news:7776AFC9-A338-403F-9716-(E-Mail Removed)...
>I usually use Int(Now). Using Int() truncates the date to just date, no
>time
> stamp.
>
>
> "Domac" wrote:
>
>> Hi,
>>
>> What is the best way to convert return value of Now() function to pure
>> Date
>> (21.062006. 15:30 => 21.06.2006.)??
>>
>>
>> Thanks!
>> Domagoj
>>
>>
>>

converting to an INT will ROUND UP won't it?

converting 1/26/2006 12:40pm to a decimail and you've got 3244.546
this rounds UP.

>From what I understand; you need to subtract .5 from a date and then
convert to an int in order to get the correct date.

-Aaron


Linc wrote:
> I usually use Int(Now). Using Int() truncates the date to just date, no time
> stamp.
>
>
> "Domac" wrote:
>
> > Hi,
> >
> > What is the best way to convert return value of Now() function to pure Date
> > (21.062006. 15:30 => 21.06.2006.)??
> >
> >
> > Thanks!
> > Domagoj
> >
> >
> >