samhsieh_
Contributor
2019-08-12
01:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to create a MoM balance sheet?
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?
625 Views
1 Solution
Accepted Solutions
rutger_jansen
Contributor III
2019-08-12
08:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try: MakeDate(2019, 7, 31) as Date,
I assume your master calendar has a field called 'Date'
regards,
Rutger
598 Views
1 Reply
rutger_jansen
Contributor III
2019-08-12
08:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try: MakeDate(2019, 7, 31) as Date,
I assume your master calendar has a field called 'Date'
regards,
Rutger
599 Views