topic Date, Year, Month in QlikView

Date, Year, Month

Thu, 19 May 2011 13:05:41 GMT

Hi Guys,

I have a field that appears like this

If i want another list bos with just the date, year or month what do I need to write in the load script. I've tried, Date(), Date#() and Date(Date#() to get date, and none work. Maybe I am using one of the above QV functions incorrectly, I dont know

Thanks,

Byron

Date, Year, Month

Thu, 19 May 2011 13:11:22 GMT

I seem to have gotten it right with this

Date(Round(DateTime,1),'YYYY/MM/DD'). If there is another way please let me know. Not sure if this method restricts my reporting in any kind of way

Date, Year, Month

Thu, 19 May 2011 13:14:51 GMT

Ok, but now another problem. I need just the time

Date, Year, Month

Thu, 19 May 2011 13:23:34 GMT

Ok got this too, but my method looks ugly

Time(DateTime-Date(Round(DateTime,1)),'hh:mm:ss') as IntervalTime

Any other suggestions????

Date, Year, Month

Thu, 19 May 2011 13:24:07 GMT

Hi,

Try this:

LOAD DateTime,

DATE(DAYSTART(DateTime), 'DD/MM/YYYY') AS Only_Date,

DATE(DateTime, 'hh:mm:ss') AS Only_Time;

...

Date, Year, Month

Thu, 19 May 2011 13:28:46 GMT

Thanks Ecorrea,

Only_Date worked but not the Only_Time. Only_Time shows me time in that format, but I would see the same time appear more than once. This is probably due to the fact that the timestamp it is linked to is picking up different dates with that time

Date, Year, Month

Thu, 19 May 2011 13:45:33 GMT

Byron, Try With this.

Date(Timestamp#(DateTime,'DD/MM/YYYY hh:mm:ss tt')) as Date,

Month(Timestamp#(DateTime,'DD/MM/YYYY hh:mm:ss tt')) as Month,

Time(Timestamp#(DateTime,'DD/MM/YYYY hh:mm:ss tt')) as Time

hope this helps you.

- Sridhar

Date, Year, Month

Thu, 19 May 2011 13:57:59 GMT

You may try this:

date( MakeDate(left(Date,4), mid(Date,5,2 ),right(Date,2 )),'YYYY/MM/DD') as [Start Period]

You can take or split what you need.I hope it helps!!

Date, Year, Month

Thu, 19 May 2011 15:33:17 GMT

Hi Scridhar,

No luck with any of those

----------------------------------------------------------------

Hi Javortiz

I can use that but all that a timestamp is, is a number with decimals. So to get date, all I need to do is remove decimals. Therefore I could use your code, but I dont really need to recreate the date, just round it down to the nearest integer.

------------------------------------------------------------------

I am currently using Eccorea's code for the date as the 'round' has issues unless I can tell it to round down.

Thanks to all for your replies and insight. Much appreciated

Cheers,

Byron

Date, Year, Month

Thu, 19 May 2011 15:35:18 GMT

The two pieces of code Im using as a final reply to this thread

Date(DayStart(DateTime)) as Date

Time(DateTime-Date(DayStart(DateTime)),'hh:mm:ss') as IntervalTime