Fiscal year format

[#1]

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:

[#2]

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

[#3]

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

[#4]

Hi Blaze

Then you use makedate() funcation.

Regards

Ashish

[#5 · Accepted solution]

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,