Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
aveeeeeee7en
Specialist III
Specialist III
‎2014-08-25 12:30 AM

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,423 Views
0 Likes
12 Replies
PrashantSangle
MVP
MVP
‎2014-08-25 01:07 AM

In response to PrashantSangle

Hi,

Please find attached file for your reference.

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 🙂
Date Format.qvw
171 Views
tresesco
MVP
MVP
‎2014-08-25 01:07 AM

In response to aveeeeeee7en

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

171 Views
aveeeeeee7en
Specialist III
Specialist III
‎2014-08-25 01:23 AM
Author

In response to er_mohit

Thank You Everyone.

171 Views
0 Likes