Combining Integer and date

[#1]

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

[#2]

use something like:

num(date#())

[erichshiino]

Hi,

You can try this:

num(INTEGER&text(date(DATE,'YYYYMMDD')))

or

num#( INTEGER&date(DATE,'YYYYMMDD'), '000000000000)

Hope it helps,

Erich

[#4]

Thank you for your suggestions. I founf out that my Integer was 15 digits long and QV only supports 14 digits integers.