Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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

Hi All,

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

Thanks,

Bibhuti

10 Replies

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

Try: floor(datetime)

- Marcus

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

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.

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

or

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.

or may be this as well:

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

Not applicable

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

Thanks ALL, I am applying these methods.

nico_ilog
Contributor II

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

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

Not applicable

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

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.

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

Best,

Sunny

nico_ilog
Contributor II

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

Hi Bibhuti,

Mark correct and helpful answer to close the thread.

Nico

Community Browser