Date to integer

[hopkinsc]

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

[#2]

You are writting this:

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

But it won't work because the formula its expecting the day and you only write jul-2013.

Try writting 01-jul-2013... or =num(Date#('Jul-2013', 'MMM-YYYY'))

[MayilVahanan]

HI

Temp:

LOAD * INLINE [

    Date, Sales

    May-2013, 1000

    Jun-2013, 2000

];

Date:

Load *,

          Num(Date#(Date,'MMM-YYYY')) as DateField

Resident Temp;

Drop table Temp;