Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aveeeeeee7en
Specialist III
Specialist III

Date Format

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

1 Solution

Accepted Solutions
PrashantSangle

Hi,

Just write ,

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

12 Replies
tresesco
MVP
MVP

Try like:

Load

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

aveeeeeee7en
Specialist III
Specialist III
Author

Sir

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

sushil353
Master II
Master II

Hi,

Try this one:

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

HTH

Sushil

tresesco
MVP
MVP

Then try without floor(), like:

Load

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

Not applicable

did you try

on the load

date(floor (SystemClosedDateTime)) as date,

PrashantSangle

Hi,

Try this,

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
er_mohit
Master II
Master II

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 


aveeeeeee7en
Specialist III
Specialist III
Author

Thanks Everyone for the Result.

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

Kindly, see the Attachment.

PrashantSangle

Hi,

Just write ,

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂