topic Re: date from Timestamp in QlikView

date from Timestamp

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

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.

Thanks in advance

Re: date from Timestamp

kakani87 — Sat, 24 Feb 2018 09:42:25 GMT

Export this date Field with timestamp into an excel and share

Re: date from Timestamp

parthesh — Sat, 24 Feb 2018 09:47:20 GMT

Hello,

try this

Date#('12/02/2018','dd/mm/yyyy')

QuarterName(Date#('12/02/2018','dd/mm/yyyy'))

Month(Date#('12/02/2018','dd/mm/yyyy'))

Year(Date#('12/02/2018','dd/mm/yyyy'))

Re: date from Timestamp

pradosh_thakur — Sat, 24 Feb 2018 09:52:09 GMT

if date is already in date format use this

Load

floor(Date) as Date,

week(floor(Date)) As Week,

Year(floor(Date)) As Year,

Month(floor(Date)) As Month,

Day(floor(Date)) As Day,

date(monthstart(floor(Date)), 'MMM-YYYY') as MonthYear,

'Q' & Ceil(Month(floor(Date) / 3) AS Quarter, as Quarter,

Week(weekstart(floor(Date))) & '-' & WeekYear(floor(Date)) as WeekYear,

WeekDay(floor(Date)) as WeekDay

from table_name;

Re: date from Timestamp

pradosh_thakur — Sat, 24 Feb 2018 09:57:12 GMT

if not in date format use this

tablename1:

load timestamp#(date,'DD/MM/YYYY hh:mm')) AS Date

from table_name;

Load

floor(Date) as Date,

week(floor(Date)) As Week,

Year(floor(Date)) As Year,

Month(floor(Date)) As Month,

Day(floor(Date)) As Day,

date(monthstart(floor(Date)), 'MMM-YYYY') as MonthYear,

'Q' & Ceil(Month(floor(Date) / 3) AS Quarter, as Quarter,

Week(weekstart(floor(Date))) & '-' & WeekYear(floor(Date)) as WeekYear,

WeekDay(floor(Date)) as WeekDay

resident table_name1;

Re: date from Timestamp

kakani87 — Sat, 24 Feb 2018 10:11:34 GMT

use this in script and front end format in Number tab as date

Properties > Number Tab > Over ride > check Date format

Date:

LOAD Date

FROM

(biff, embedded labels, table is Sheet1$);

Load

date(floor(Date)) as Date,

Year(floor(Date)) As Year,

Month(floor(Date)) As Month,

Day(floor(Date)) As Day,

date(monthstart(floor(Date)), 'MMM-YYYY') as MonthYear,

'Q' & Ceil(Month(floor(Date) / 3)) AS Quarter

Resident Date;

Re: date from Timestamp

kakani87 — Sat, 24 Feb 2018 10:16:16 GMT

In the script replace

date(floor(Date)) as Date with Date(Date, 'MM/DD/YY') as Dt

not even required to format in front end