date & time feild

[Anonymous]

hi,

i have feild with date & time  (08-01-2018 15:39:03) , i want to make only date.

i write "date(ontdate)" as date

the result is -  new feild "date"  with the date , but i can't chose one date for all the data.

if i click on 08-01-2018 i only get 1 row that , not all the rows that happend on 08-01-2018.

hope it's undestood.

thanks'

yarin.

[prma7799]

Have you tried this

Date(date#('08-01-2018','MM-DD-YYYY'))

or

Date(date#('08-01-2018','MM-DD-YYYY') , 'MM-DD-YYYY')

[tamilarasu]

Hi Yarin,

Try this.

Date#(Subfield(ONDATE,' ',1),'DD-MM-YYYY') as Date

Or

Date(Date#(Subfield(ONDATE,' ',1),'DD-MM-YYYY'),'DD-MM-YYYY')  as Date

[Anonymous · Accepted solution]

i used the function

MakeDate(Year(ondate),Month(ondate),Day(ondate))

and it's working good.

thanks'