I have datetime in this format 7/1/2014 0:00. How to retrieve only date from this.

[#1]

Hi All,

I have datetime in this format 7/1/2014 0:00. How to retrieve only date from this.

Thanks,

Bibhuti

[marcus_sommer]

Try: floor(datetime)

- Marcus

[sunny_talwar]

I agree with Marcus, but would add Date() function to show the date

Date(Floor(datetime)) as Date

[MK_QSL]

Date(Floor(TimeStamp#(YourDateTimeField,'D/M/YYYY h:mm'))) as Date   

or

Date(Floor(TimeStamp#(YourDateTimeField,'M/D/YYYY h:mm'))) as Date

[sunny_talwar]

or may be this as well:

Date(Date#(SubField(datetime, ' ', 1), 'M/D/YYYY')) as Date

[#6]

Thanks ALL, I am applying these methods.

[nico_ilog]

This works for me..

Date(num(left(Your_Date_Field,5))) as Your_Date_Field_Name

Give it a try and let me know?

Nico

[#8]

Thanks All,

It's working...

Thanks Everyone for your response.

[sunny_talwar]

Great. Mark correct and helpful answer to close the thread.

Best,

Sunny

[nico_ilog]

Hi Bibhuti,

Mark correct and helpful answer to close the thread.

Nico