convert to num

[soniasweety]

Hi all

I have a field like   dateJo   values like   1-Apr-17   ,1-Jan-17  like so on

when I tried   num(dateJo) as  NewDate   it is giving me null

how to convert this?

[PrashantSangle]

can you post your script??

if possible provide sample data.

Regards

[Anil_Babu_Samineni]

Have you tried at least? Copy and paste then reload() and show the image of field to check

[sasikanth]

HI,

i think there might be an issue with date format,

try this

LOAD  alt(num(Date#(dateJo,'DD-MMM-YY')),num(Date(dateJo,'DD-MM-YYYY' ))) as NewDate

Inline [

dateJo

1-Apr-17

17-Jan-01

];

OR

LOAD  alt(num(Date#(dateJo,'DD-MMM-YY')),num(Date(Date#(dateJo,'DD-MM-YYYY hh:mm:ss'  )))) as NewDate

Inline [

dateJo

1-Apr-17

17-Jan-01

];

[sasikanth]

HI,

Code works with out any issues & it will convert a date into number, usage of Month() function will give you month number.

[shiveshsingh]

try this

=num(DATE(Date#(Field,'DD/MM/YYYY'),'mm/dd/yy)')

[luciano_garcia]

Hi soniasweety‌

Check the existence of special chars in your column data (as TAB, or hair spaces, or thin spaces, e.g.)