Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

In the script:

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

View solution in original post

6 Replies
sasiparupudi1
Master III
Master III

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

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

sunny_talwar

Try this:

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

sunny_talwar

In the script:

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

Not applicable
Author

thanks a lot. i´s running

sunny_talwar

‌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
Author

thanks