Remove minutes and seconds in the date

[#1]

Hello everyone ,
I have a problem that concerns the date .
I have a golf date : 07/20/2014 00 : 00.00 . How can I remove the minutes and seconds remaining intact date .
Thank you

[sunny_talwar]

Try this may be:

Date(Floor([golf date])) as [golf date]

[arulsettu]

try like this

date(floor(golf date) )as date

[sunny_talwar]

Although you did not mention hours here, but I assume you want to get rid of hours as well?

[avinashelite]

As per your statement you need to only remove the mins and sec not the hours?? or do you need to remove the entire time portion, if that is the requirement then:

date(floor([golf date]) )as date

if you need hr with the date, then

timestamp([golf date],'DD-MM-YYYY HH')

[stephenedberkg]

try this

Date#( DateField, 'M/D/YY') as Date

[#7]

That's right , even the hours , but I would like to remove the script is the same ? Date(Floor([golf date])) as [golf date]

[PrashantSangle]

Hi,

Simply use Date()

Date(FieldName)

Regards

[Anonymous]

Try

MakeDate(golf date) as DateField

or

Date(TimestampFormat(golf date)) as DateField

Thanks,

Bunny

[#10]

Thank you all for your help