Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Convert Date in Date number like Excel Date number

hi,

I´m new in QS and I need to convert Date to a Number Date, for example

 

01-09-2015          42.248
02-09-2015          42.249
03-09-2015          42.250

a) I have a File name : 01-09-2015 NOM.xlxs

b) I have Date in Text Format : Replace ( Left( FileName(), 10 ) , '-' , '/' )

know, I need to convert this Date in Number (like Excel number)

regards.

1 Solution

Accepted Solutions
MVP
MVP

Re: Convert Date in Date number like Excel Date number

In the script:

Num(Date#(Replace(Left(FileName(), 10), '-' , '/' ), 'DD/MM/YYYY')) as NumDate

6 Replies
sasiparupudi1
Honored Contributor III

Re: Convert Date in Date number like Excel Date number

num(date#('01-09-2015','DD-MM-YYYY'))

num(date#(YourDateField,'DD-MM-YYYY'))

MVP
MVP

Re: Convert Date in Date number like Excel Date number

Try this:

=Num(Date#(Replace(Left('01-09-2015 NOM.xlxs', 10 ) , '-' , '/' ), 'DD/MM/YYYY'))

MVP
MVP

Re: Convert Date in Date number like Excel Date number

In the script:

Num(Date#(Replace(Left(FileName(), 10), '-' , '/' ), 'DD/MM/YYYY')) as NumDate

Not applicable

Re: Convert Date in Date number like Excel Date number

thanks a lot. i´s running

MVP
MVP

Re: Convert Date in Date number like Excel Date number

‌Awesome  

I am glad its working. If you are satisfied with the solution, I would recommend closing the thread by marking correct answer and/or any helpful answers.

Best,

Sunny

Not applicable

Re: Convert Date in Date number like Excel Date number

thanks