How to create a MoM balance sheet?

[samhsieh_]

As title. I've imported two balance sheets from excel, but they're without  the date.

So I manully add the date by this:

Emp_temp:
LOAD *,
'2019/07/31' as Date 
Resident Balance_sheet_201907;
DROP Table Balance_sheet_201907; 

However, Mastercalendar doesn't work with it.

How can I fix that?

[rutger_jansen · Accepted solution]

Hi,

Try:  MakeDate(2019, 7, 31) as Date,

I assume your master calendar has a field called 'Date'

regards,

Rutger