Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Fiscal year format

Hey guys.

I finally got fiscal year working and every things cool 100%. Only problem is that its seems to be in a different format. it looks like this:

error loading image

1 Solution

Accepted Solutions
Not applicable
Author

Got it working. problem was that the raw data was in a timestamp format. The soluton i used was this

LOAD Date(Floor(OrderDate)) as OrderDate,

View solution in original post

4 Replies
Not applicable
Author

Hi,

You can use Date(Due_Date,'DD-MM-YYYY') or Date(Due_Date,'MM-DD-YYYY') e.t.c for changing the format.

Regards,

Ravi

Not applicable
Author

I have already tried those formulas and ive tried date(date#(OrderDate),'YYYY/MM/DD'),'DD/MM/YYYY') and nothing works

Not applicable
Author

Hi Blaze

Then you use makedate() funcation.

Regards

Ashish

Not applicable
Author

Got it working. problem was that the raw data was in a timestamp format. The soluton i used was this

LOAD Date(Floor(OrderDate)) as OrderDate,

View solution in original post