Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
In the script:
Num(Date#(Replace(Left(FileName(), 10), '-' , '/' ), 'DD/MM/YYYY')) as NumDate
num(date#('01-09-2015','DD-MM-YYYY'))
num(date#(YourDateField,'DD-MM-YYYY'))
Try this:
=Num(Date#(Replace(Left('01-09-2015 NOM.xlxs', 10 ) , '-' , '/' ), 'DD/MM/YYYY'))
In the script:
Num(Date#(Replace(Left(FileName(), 10), '-' , '/' ), 'DD/MM/YYYY')) as NumDate
thanks a lot. i´s running
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
thanks