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: 
dreweezy
Partner - Creator II
Partner - Creator II

date format & timestamp format

I've got a date column that displays it as -- '2019-07-31 00:00:00.000000'

I'd like to do some manipulation in qlik and also have it very simple to show it in a format such as 'MM/DD/YYYY'

I've tried to do a few manipulation hoping to produce it in that format but ends up being null. 

Syntax that has been tried:

1. Date(Date#([marketingDate], 'MM/DD/YYYY') ) AS [Marketing Date]

2. Timestamp(Timestamp#([marketingDate], 'YYYY/MM/DD hh:mm:ss') ,'MM/DD/YYYY') AS [Marketing ]

Still ends up showing either wrong or empty.

 

Labels (2)
2 Solutions

Accepted Solutions
dreweezy
Partner - Creator II
Partner - Creator II
Author

Solution:

Date([YOURFIELDDATE], 'MM-DD-YYYY') as [DATE]

View solution in original post

Frank_Hartmann
Master II
Master II

Maybe this:

 

if([marketingDate] - [financeDate] < 30, green(),
if(([marketingDate] - [financeDate]) > 30 and [marketingDate] - [financeDate]) < 90, lightred())

View solution in original post

6 Replies
Frank_Hartmann
Master II
Master II

try this:

date(date#(left([marketingDate],10),'YYYY-MM-DD'),'MM/DD/YYYY') AS [Marketing Date]
dreweezy
Partner - Creator II
Partner - Creator II
Author

Does not work. Any other suggestions? Feel like this is something that should be a simple fix.

dreweezy
Partner - Creator II
Partner - Creator II
Author

Solution:

Date([YOURFIELDDATE], 'MM-DD-YYYY') as [DATE]

dreweezy
Partner - Creator II
Partner - Creator II
Author

Hey Frank thanks for your help. Wondering if you can help me out with my syntax.

I am coloring cells depending on what different in days.

if(
[marketingDate] - [financeDate] < 30, green(),
if(([marketingDate] - [financeDate]) > 30 and < 90, lightred())

My syntax is wrong and wondering how to set up the in between factor when running an if statement in qlik.

Thanks.

Frank_Hartmann
Master II
Master II

Maybe this:

 

if([marketingDate] - [financeDate] < 30, green(),
if(([marketingDate] - [financeDate]) > 30 and [marketingDate] - [financeDate]) < 90, lightred())

dreweezy
Partner - Creator II
Partner - Creator II
Author

Thanks Frank. Works like a charm.