convert date into fiscal id

[Karim_Khan]

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

stalwar1‌kush141087‌sureshqv‌QlikView Forums & Resources‌

[bindu_apte]

Hi,

Hope this thread will help.

Convert date format to numeric | Qlik Community

[PrashantSangle · Accepted solution]

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