What is the function used to exclude the time value from a date/time variable

[accesser2003]

I want to exclude the time value from a date/time variable without affecting the date/time format of the user.

For example if the date/time variable is "1/12/2007 09:12:46", I want to get the value as "1/12/2007".

I dont want to use the format("dd/mm/yyyy") function because it will affect the user format for the dates. For the same reason, I dont want to use the function day(), month(),year().

How can achieve this without affecting the user format?

 

[pbaldy]

Does DateValue do what you want?

 

[accesser2003]

it works.

thanks,