Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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