conversion of date

[#1]

Hi Community,

     I tried to change my date field from string to number.not able to resolve

     please help  me

[MK_QSL]

=Date(Date#(date,'DD-M-YYYY'))

and

=NUM(Date(Date#(date,'DD-M-YYYY')))

[ashfaq_haseeb]

try below

Alt( Date(Date#( [date] , 'DD-MM-YYYY' ),'DD-MM-YYYY'),

      Date(Date#( [date] , 'DD-M-YYYY'),'DD-MM-YYYY')) AS NewDate,

Regards

ASHFAQ

[suzel404]

Attachement!

[#5]

= date(date#(date,'ddmmyyyy'))

[#6]

i want to dervie month and year fields how can i get that?

[tresesco]

Date(num(Date#([date] ,'DD-MM-YYYY')),'DD-MM-YYYY') as new_date,

can be written in an easier way like:

Date(Date#([date] ,'DD-MM-YYYY'),'DD-MM-YYYY') as new_date,

Month(Date#([date] ,'DD-MM-YYYY')) as new_Month,

Year(Date#([date] ,'DD-MM-YYYY')) as new_Year,

[#8]

year(= date(date#(date,'ddmmyyyy'))) as year,

month(= date(date#(date,'ddmmyyyy'))) as month

[ashfaq_haseeb]

Like this.

LOAD cust_id,

     date,

     Date(Date#(date,'DD-MM-YYYY')) as Date,

     Month(Date#(date,'DD-MM-YYYY')) as Month,

     Year(Date#(date,'DD-MM-YYYY')) as Year,

     sale

From

practice.xlsx

(ooxml, embedded labels, table is Sheet1);

Regards

ASHFAQ

[its_anandrjs · Accepted solution]

Hi Sruti,

Some of the very simple way try this load script for date, month and year

LOAD cust_id,

     date,

     Date(Date#(date,'DD-MM-YYYY')) as Date,

     Month(Date#(date,'DD-MM-YYYY')) as Month,

     Year(Date#(date,'DD-MM-YYYY')) as Year,

     sale,

     Date(Date#("date",'DD-M-YYYY')) as NewDate,

     Year(Date(Date#("date",'DD-M-YYYY'))) as NewYear,

     MOnth(Date(Date#("date",'DD-M-YYYY'))) as NewMonth

From

practice.xlsx

(ooxml, embedded labels, table is Sheet1);