date

[smilingjohn]

Hi All,

I have field called date and the format is shown in the below screenshot.

if you look at the date for 16-Oct it is repeated three times because of the different time seconds ..

I am trying to get only unique date as 16- October by writing the below script .

  Date#(Date(date,'MM/DD/YYYY:hh:mm:ss'),'MM-dd-yyyy') as date

but still i am getting the same thing ..how can i make it one date ....

Thanks in advance

[smilingjohn · Accepted solution]

This is simple

i got it ..i need to write it like this

date#(date(date ),'DD.MM.YYYY') as date ,

[Anil_Babu_Samineni]

Try this?

Date(Date#(date,'MM/DD/YYYY:hh:mm:ss'),'DD-MMM')

Or

Date(Floor(Date#(date,'MM/DD/YYYY:hh:mm:ss')),'DD-MM-YYYY')

[arvind_patil]

Hi John,

Try Below :

  Date(Floor(date Field))  as Date

Thanks,

Arvind Patil