Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
haymarketpaul
Contributor III

Changing Date Format

QV12 SR4

I've got some dates in this format:-

Fri Feb 08 2019 14:37:53 GMT+0000 (UTC)

I need just the date portion in this format:-

DD/MM/YYYY

Thought i might be able to do this sort of thing but they all end up blank for some reason?

Date(Date#(SubField(Mid(MyRegDate,4,Len(MyRegDate)),' G',1),'MMM DD YYYY hh:mm:ss'),'DD/MM/YYYY') as [Reg Date],

Any ideas

Labels (2)
1 Solution

Accepted Solutions
haymarketpaul
Contributor III

Re: Changing Date Format

 

Just had the wrong number in the Mid statement...

 

Date(Date#(SubField(Mid(MyRegDate,5,Len(MyRegDate)),' G',1),'MMM DD YYYY hh:mm:ss'),'DD/MM/YYYY') as [Reg Date],

View solution in original post

1 Reply
haymarketpaul
Contributor III

Re: Changing Date Format

 

Just had the wrong number in the Mid statement...

 

Date(Date#(SubField(Mid(MyRegDate,5,Len(MyRegDate)),' G',1),'MMM DD YYYY hh:mm:ss'),'DD/MM/YYYY') as [Reg Date],

View solution in original post