Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

convert date into fiscal id

Hi Team,

    I want to convert my noramal date into fiscal ID.

Suppose i have date 06-APR-05

I wanted to change it into 20050406 and

weekd id --200514

Month ID --200504

QuarterID --20052

etc.

Regards,

KK

stalwar1kush141087sureshqvQlikView Forums & Resources

KK
1 Solution

Accepted Solutions
Highlighted

Hi,

If your date field in date datatype then

try

date(DateField,'YYYYMMDD')

If it not in date datatype then

date(date#(dateField,'YYYY-MMM-DD'),'YYYYMMDD')

go to help menu

see

weekName()

MonthName()

Explore other date function also.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

2 Replies
Highlighted
Creator III
Creator III

Hi,

Hope this thread will help.

Convert date format to numeric | Qlik Community

Highlighted

Hi,

If your date field in date datatype then

try

date(DateField,'YYYYMMDD')

If it not in date datatype then

date(date#(dateField,'YYYY-MMM-DD'),'YYYYMMDD')

go to help menu

see

weekName()

MonthName()

Explore other date function also.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post