Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all, can anyone help me on how to convert a date field (MMM-YYYY) to an interger?
HI
=num(Date#('JUL-2013' , 'MMM-YYYY'))
Hope it helps
num(datefield)
Hi
Try like this
= Floor(dateField)
Hope it helps
Hi, i am not sure what i am doing wrong but if i create a text box and use =num('JUL-2013') i get null.
Try this
TRY ANY ONE OF THEM
ROUND(dateField)
FLOOR(dateField)
NUM(dateField)
=ROUND(date(today(),'MMM-YYYY' ))
=NUM(date(today(),'MMM-YYYY' ))
OR THIS ONE
=NUM(date(DATEFIELD,'MMM-YYYY' ))
HI
=num(Date#('JUL-2013' , 'MMM-YYYY'))
Hope it helps
num('JUL-2013')
Here, you are trying to convert a string to number. Qlikview doesn't understand it unless you tell him that it's a date:
num(Date#('11-Jul-2013', 'DD-MMM-YYYY'))
TRY THIS
NUM(DATE#('JUL-2013','MMM-YYYY'))
Hi Everyone,
Thanks for your replies although i cannot seem to get any of them to work correctly.
I have attached a sample, could someone show me the correct way on the sample please?
So i want the current date format 'JUL-2013' to show the number format (month start)
Thanks