topic Re: Date Format in QlikView

Date Format

aveeeeeee7en — Mon, 25 Aug 2014 04:30:12 GMT

Hi All

I have date field in this Format: 07-08 8-2013 12:44:11

I need date field in this Format: 07-08-2013 12:44:11

Only Month is in different Format.

I am getting desired result by using this:

SubField(SystemClosedDateTime,'-',1)&'-'&Left(SubField(SystemClosedDateTime,'-',2),2)&'-'&Left(SubField(SystemClosedDateTime,'-',3),4)

Is there any other way which will only change the month Format (08 😎 and rest Date and Year work as it is.

Regards

Aviral Nag

Re: Date Format

tresB — Mon, 25 Aug 2014 04:32:20 GMT

Try like:

Load

Date(Floor(Timestamp#(YourDate, 'DD-MM M-YYYY hh:mm:ss'))) as Date

Re: Date Format

aveeeeeee7en — Mon, 25 Aug 2014 04:34:15 GMT

Sir

I need this Format: 07-08-2013 12:44:11

Re: Date Format

sushil353 — Mon, 25 Aug 2014 04:35:09 GMT

Hi,

Try this one:

=Date(Date#(SystemClosedDateTime,'DD-MM D-YYYY hh:mm:ss'),'DD-MM-YYYY hh:mm:ss')

HTH

Sushil

Re: Date Format

tresB — Mon, 25 Aug 2014 04:37:14 GMT

Then try without floor(), like:

Load

Timestamp(Timestamp#(YourDate, 'DD-MM M-YYYY hh:mm:ss')) as Date

Re: Date Format

Mon, 25 Aug 2014 04:40:41 GMT

did you try

on the load

date(floor (SystemClosedDateTime)) as date,

Re: Date Format

PrashantSangle — Mon, 25 Aug 2014 04:48:05 GMT

Hi,

Try this,

Timestamp(Timestamp#(DateFieldName, 'DD-MM M-YYYY hh:mm:ss'),'DD-MM-YYYY hh:mm:ss') as newDate

Regards

Re: Date Format

er_mohit — Mon, 25 Aug 2014 04:48:32 GMT

Try this in text object

Timestamp(Timestamp#('07-08 8-2013 12:44:11', 'DD-MM f-YYYY hh:mm:ss'))

you get this output 07-08-2013 12:44:11

hope it helps

Re: Re: Date Format

aveeeeeee7en — Mon, 25 Aug 2014 04:56:56 GMT

Thanks Everyone for the Result.

I've applied everyone's logic but it's not working perfectly.

Kindly, see the Attachment.

Re: Date Format

PrashantSangle — Mon, 25 Aug 2014 05:05:15 GMT

Hi,

Just write ,

Timestamp(SystemClosedDateTime,'DD-MM-YYYY hh:mm:ss')

Regards,

Re: Re: Date Format

PrashantSangle — Mon, 25 Aug 2014 05:07:15 GMT

Hi,

Please find attached file for your reference.

Regards,

Re: Date Format

tresB — Mon, 25 Aug 2014 05:07:17 GMT

Your data is properly formatted, it is just been shown like that. Goto number tab, select timestamp as format.

Re: Date Format

aveeeeeee7en — Mon, 25 Aug 2014 05:23:33 GMT

Thank You Everyone.