Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this may be:
Date(Floor([golf date])) as [golf date]
try like this
date(floor(golf date) )as date
Although you did not mention hours here, but I assume you want to get rid of hours as well?
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')
try this
Date#( DateField, 'M/D/YY') as Date
That's right , even the hours , but I would like to remove the script is the same ? Date(Floor([golf date])) as [golf date]
Hi,
Simply use Date()
Date(FieldName)
Regards
Try
MakeDate(golf date) as DateField
or
Date(TimestampFormat(golf date)) as DateField
Thanks,
Bunny
Thank you all for your help