Date to integer

[hopkinsc]

hi all, can anyone help me on how to convert a date field (MMM-YYYY) to an interger?

[#2]

num(datefield)

[MayilVahanan]

Hi

Try like this

= Floor(dateField)

Hope it helps

[hopkinsc]

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.

[rustyfishbones]

Try this

[#6]

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' ))

[MayilVahanan · Accepted solution]

HI

=num(Date#('JUL-2013' , 'MMM-YYYY'))

Hope it helps

[#8]

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'))

[#9]

TRY THIS

NUM(DATE#('JUL-2013','MMM-YYYY'))

[hopkinsc]

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