Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Use This formula:
=Date((MinutesField/(60*24))+32143,'DD-MM-YYYY hh:mm')
Hope this helps you.
Regards, tresesco
Date(Date1,'DD/MM/YYYY hh:mm')
Use This formula:
=Date((MinutesField/(60*24))+32143,'DD-MM-YYYY hh:mm')
Hope this helps you.
Regards, tresesco
Thanks for your quick answer!
it's works.
Hi.
I had the script:
Aline:
SQL SELECT
PART,
CURDATE
FROM ZZZ.dbo.ALINE;
and I want to post on edit script, at SQL select statment (somthing like this):
SQL SELECT PART, CURDATE,
Date((CURDATE/(60*24))+32143,'DD-MM-YYYY hh:mm') as "Aline_Curdate",
Year(Aline_Curdate) as "Aline_Year_Curdate",
Month(Aline_Curdate) as "Aline_Month_Curdate",
Day(Aline_Curdate) as "Aline_Day_Curdate"
from .....
How can I do this?
Tnks.
Hi,
use your script with LOAD rather than in SQL SELECT. I mean once it is fetched from the base database using SQL SELECT you should use LOAD command to allow QV work upon it so that all QV specific commands are supported.