Discussion Board for collaboration on QlikView Scripting.
This seems like it should be simple but couldn't find the exact documentation for it.
I need to change a date so it becomes January 1st of the same year: 12/1/2013 becomes 01/01/2013, 05/05/2012 becomes 01/01/2012, 10/15/2011 becomes 01/01/2011 etc.
Go to Solution.
yearstart= first ms of the year
floor=will round it
date=makes the integer to date
Thanks - don't know how I missed that!