Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bhavvibudagam
Contributor II

Date from Timestamp()

Hi Experts,

Can any one please help me on this.

I have a date field like below in Time stamp format.

How to extract the Date, Quarter and Monthyear from below field.

Date.png

Thanks in advance

1 Solution

Accepted Solutions
omarbensalem
Esteemed Contributor

Re: Date from Timestamp()

load dateField , (Date(monthstart(dateField), 'MMM-YYYY')) as MonthYear,

'Q' & ceil(month(dateField)/3) as Quarter;

load date(Timestamp#(timestampField,'DD/MM/YYYY hh:mm')) as dateField;

load * Inline [

timestampField

04/12/2017 11:57

04/12/2017 14:40

07/12/2017 12:58

08/01/2018 17:22

08/11/2017 13:24

10/11/2017 14:25

11/12/2017 16:00

];

Result:

Capture.PNG

1 Reply
omarbensalem
Esteemed Contributor

Re: Date from Timestamp()

load dateField , (Date(monthstart(dateField), 'MMM-YYYY')) as MonthYear,

'Q' & ceil(month(dateField)/3) as Quarter;

load date(Timestamp#(timestampField,'DD/MM/YYYY hh:mm')) as dateField;

load * Inline [

timestampField

04/12/2017 11:57

04/12/2017 14:40

07/12/2017 12:58

08/01/2018 17:22

08/11/2017 13:24

10/11/2017 14:25

11/12/2017 16:00

];

Result:

Capture.PNG