Date transformation

[mario-sarkis]

hi all

i have a field with this form 6/1/2016 (jun 1-2016) i need to transform it to a number as 42522

hope u can help thanks

‌

[MindaugasBacius]

LOAD Value
     ,date#(Value, 'DD/MM/YYYY') as Date
     ,num(date#(Value, 'DD/MM/YYYY')) as Date_num
INLINE [
    Value
    6/1/2016
];

Result:

[migueldelval]

Hi Mario,

Try with this expression: =Num#(6/1/2016, '##,##')

Regards

Miguel del Valle

[MK_QSL]

Set below in your script..

SET DateFormat='M/D/YYYY';

Now use

Num(YourDateField) as DateFieldinNum

in script.

or

=Num(YourDateField) in text box or chart

[tamilarasu]

You can try in either load script or expression like below,

Num(Date#(DateField,'M/D/YYYY'))

[Chanty4u]

try this

Num(Date#(DateField,'M/D/YYYY'),'M/D/YYYY') AS newdate

[susovan]

You can also try this,

Month:

LOAD * INLINE [

Month_Date

6/1/2016

];

LOAD *,

Num(Month_Date) as @_Month_Date Resident Month

[vcanale]

Hi,
try
=NUM(Date#(FieldName,'M/D/YYYY'), ##,##0)