Discussion Board for collaboration on QlikView Scripting.
I have an unusal date field: 2008-05-29T11:00:00Z I dont need the time on the end I just want to pull out the year, month and date as separte fields.
Can anyone offer an suggestions. Ideally like to do this in the script so I can pass on to others.
Go to Solution.
see attached document.
uses left() on the date field to strip out the part you need
what you can do is =Date(DateTimeField,'DD-MMM-YYYY'
If you have fixed format of this filed then you can also use subfield() function
Try Floor and date functions
Date(Floor(DateTimeField), 'DD/MM'YYYY) As Date,
Year(Date(Floor(DateTimeField), 'DD/MM'YYYY) as Year,
Month(Date(Floor(DateTimeField), 'DD/MM'YYYY) as Month
Hope it helps