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

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

Thu, 03 Dec 2015 19:34:34 GMT

Hi All,

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

Thanks,

Bibhuti

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

marcus_sommer — Thu, 03 Dec 2015 19:37:27 GMT

Try: floor(datetime)

- Marcus

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

sunny_talwar — Thu, 03 Dec 2015 19:38:43 GMT

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

Date(Floor(datetime)) as Date

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

MK_QSL — Thu, 03 Dec 2015 19:44:17 GMT

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

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

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

sunny_talwar — Thu, 03 Dec 2015 19:49:30 GMT

or may be this as well:

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

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

Thu, 03 Dec 2015 19:54:31 GMT

Thanks ALL, I am applying these methods.

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

nico_ilog — Thu, 03 Dec 2015 20:37:09 GMT

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

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

Fri, 04 Dec 2015 07:55:12 GMT

Thanks All,

It's working...

Thanks Everyone for your response.

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

sunny_talwar — Fri, 04 Dec 2015 14:36:21 GMT

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

Best,

Sunny

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

nico_ilog — Fri, 11 Dec 2015 07:52:23 GMT

Hi Bibhuti,

Mark correct and helpful answer to close the thread.

Nico

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

paul_scotchford — Fri, 11 Dec 2015 08:25:28 GMT

‌that works fine