topic Re: Date in QlikView

Date

Wed, 09 Mar 2016 02:24:55 GMT

Hi Experts,

I am getting data source files date in this format " 12/12/2015 9:00:00 AM " but going forward I will get date format like " 12/12/2015 9:00:00 09" in place of "AM" I will get some number. Anyhow am not using time part in my dashboard. But if they change date format will it impact my current dashboard? Please Suggest me

Thank You

Re: Date

sunny_talwar — Wed, 09 Mar 2016 02:33:00 GMT

May be truncate the time part:

Date(Date#(Left(TimeStampField, 10), 'MM/DD/YYYY')) as Date

Assuming your date format is MM/DD/YYYY

Re: Date

Wed, 09 Mar 2016 02:51:38 GMT

Hi Sunny,

I am loading data in this format

Date(Floor(Date#(Extraction_Date, 'YYYY-MM-DD hh:mm:ss TT'))) AS ExtractionDate. But in Dashboard am using 'DD-MMM-YYYY' format. If they change in data source will it impact to Dashboard? Now in data source they were planning to add some number in place of "AM & PM "

Re: Date

settu_periasamy — Wed, 09 Mar 2016 03:14:19 GMT

Hi Jack,

Suppose if you are getting the format "12/12/2015 9:00:00 09", your mentioned statement won't work. May be you can change your statement as suggested by sunny.

or you can try this too.

=Date(Floor(Date#(SubField('2015-12-12 9:00:00 09',' ',1),'YYYY-MM-DD')))

Re: Date

Wed, 09 Mar 2016 03:35:48 GMT

Sorry,

My Date format is now " 12/12/2015 9:00:00 AM " in AM & PM format. Going forward it will change to 24 hour format no more AM & PM in Date.

For example: Time Part

09:30 AM to 09:30

01:25 PM to 13:25

11:59 PM to 23:59

So this changes will impact my current dashboard?

Re: Date

jagan — Wed, 09 Mar 2016 03:46:48 GMT

Hi,

If you are not using Time part then try like below

LOAD

Date(Date#(Left(FieldName, 10), 'MM/DD/YYYY'), 'DD-MMM-YYYY') as Date,

FROM DataSource;

Regards,

jagan.

Re: Date

jagan — Wed, 09 Mar 2016 03:47:40 GMT

Yes this will impact. If you are not using Time part then use like below

LOAD

Date(Date#(Left(FieldName, 10), 'MM/DD/YYYY'), 'DD-MMM-YYYY') as Date,

Regards,

Jagan.

Re: Date

Wed, 09 Mar 2016 04:14:35 GMT

Thank You All