How to convert Date into Number(int)

[#1]

Hi All,

I was wondering how to convert DateTime field into Number(Int not decimal)

TestTemp:
load * Inline
[
TestDate
2010/01/01 12:13:00
];

load num(TestDate) as DateNum Resident TestTemp;

But you can see that the TestDate has time, so how to get the int number with num function?

Many thanks.

[its_anandrjs]

Hi,

Use Date#( Datefield ) as NumDate to convert date into num

Rgds

Anand

[its_anandrjs · Accepted solution]

Hi,

You are able to use

Floor( Date ( Today( ) , 'DD/MM/YYYY' ) )

Let me know

Rgds

Anand

[SunilChauhan]

try this

TestTemp:
load * Inline
[
TestDate
01/01/2011 12:13:00
];

load num(TestDate) as DateNum Resident TestTemp;

format of date should be same as format defined using set in start of edit script

[its_anandrjs]

Hi,

See the attached sample file.

Your inline date is not in date format.

Rgds

Anand

[its_anandrjs]

Hi,

Let see your date example for this date 2010/01/01 12:13:00 in sample file.

Let me know about this.

Rgds

Anand

[SunilChauhan]

only you need to match the format of date given in load statement and format of date defined in start of coding.

both should be same

see my post above

[its_anandrjs]

Hi,

Hope you got correct answer, if so mark it correct\Helpful on post to complete the thread.

Rgds

Anand