Problem with relations

[#1]

Hello,

what am I doing wrong though I get two types of period, one from the budget and one from Fakturor/Calendar1?

I´m not able to show values from the budget and sales at the same time, see attached qv. !

[Anonymous]

your Period from Budget2016 is recognized as text (left aligned) while theother field Period contain dateformat (right aligned)

you Need to Format Period from Budget2016 as date using  date#(Period,'YYYYMM')

[#3]

Hello again,

but Period comes fron the CrossTable:  CrossTable(Period,Amount)

I have tried to format this like CrossTable(date#(Period,'YYYYMM'),Amount) but this doesn´t work.

[Anonymous · Accepted solution]

then try to load the table again

load into temporary table

Tmp:

load date#(Period,'YYYYMM') as Period,

other field

resident Budget2016;

drop table Budget2016;

rename table Tmp to Budget2016;

[#5]

I made it with a temporary table and load resident.

Thanks for all help.

Håkan