Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mario-sarkis
Creator II
Creator II

Date transformation

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

7 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

LOAD Value

     ,date#(Value, 'DD/MM/YYYY') as Date

     ,num(date#(Value, 'DD/MM/YYYY')) as Date_num

INLINE [

    Value

    6/1/2016

];

Result:

Screenshot_1.jpg

migueldelval
Specialist
Specialist

Hi Mario,

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

Regards

Miguel del Valle

MK_QSL
MVP
MVP

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
Champion
Champion

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

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

Chanty4u
MVP
MVP

try this

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

susovan
Partner - Specialist
Partner - Specialist

You can also try this,

Month:

LOAD * INLINE [

Month_Date

6/1/2016

];

LOAD *,

Num(Month_Date) as @_Month_Date Resident Month

Warm Regards,
Susovan
vcanale
Partner - Creator II
Partner - Creator II

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