Convert Date in Date number like Excel Date number

[#1]

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.

[sasiparupudi1]

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 · Accepted solution]

In the script:

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

[#5]

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

[#7]

thanks