Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I'm trying to combine Integer '1234' and Date together.
I've tried everything but QV keeps changing my datatype to text.
Here's an example:
INTEGER&date(DATE,'YYYYMMDD') as FINALRESULT
I want FINALRESULT to be in Integer format not in String because I need to use Intervalmatch later.
Thank you!!!
-Mikael
use something like:
num(date#())
Hi,
You can try this:
num(INTEGER&text(date(DATE,'YYYYMMDD')))
or
num#( INTEGER&date(DATE,'YYYYMMDD'), '000000000000)
Hope it helps,
Erich
Thank you for your suggestions. I founf out that my Integer was 15 digits long and QV only supports 14 digits integers.