Return just Date: 30/01/2011 21:05:00

[Minkowski]

hello everyone

30/01/2011 21:05:00

which function can i use to get the 30/01/2011 only?

thanks in advance!

 

[Matty]

Why not just Custom format the Cell as:

dd/mm/yyyy

Matty

 

[Minkowski]

yes you are right


thanks!!

 

[Norie]

If you want/need the date value one function you could use is INT.

That gets rid of the decimal part (the time) and returns the integer part (the date).

 

[Minkowski]

actually i wanted this more for access

so i went with:

Date: Format([date],"dd/mm/yyyy")

it looks ok

Norie this doesn't work for me:

=INT(30/01/2011  21:05:00)

it says the formula contains an error

 

[Norie]

INT will work in Access too.

INT([datefield])

If this is actually for Access though, and all you are concerned with is how the date is displayed you don't need any formula.

Just select the format you want for the field's properties in design view of the table in comes from.

If it's on a form or report that format should carry through but if it doesn't you can just use the Format property of the control that's displaying the field.

PS You should avoid using Date for a field name or alias, Date is a function that, well, returns the current date.

 

[Minkowski]

PS You should avoid using Date for a field name or alias, Date is a function that, well, returns the current date.

you are absolutely right my mistake!
thanks again!