Re: Help getting going with Dates/Times/TimeBuckets
it looks like your dates are stored as strings and not timestamps. An easy way to tell is to preview the data and see if the values appear right-justified (numbers and timestamps) or left-justified (strings).
In case your dates are strings, you need to convert the string to the proper timestamp data type. Something like this should work:
timestamp#(MyDate, 'MMMM D YYYY hh:mm TT')
Then, you might want to format the result using a new format pattern:
timestamp(timestamp#(MyDate, 'MMMM D YYYY hh:mm TT'), 'new format patten')
Once this is done, you can use QlikView Date functions to calculate Year, Month, WeekDay, Hour, and whatever else you need.
If you'd like to learn QlikView development techniques methodically, starting from the basics and going into the most advanced topics, check out my new book QlikView Your Business.