I'm currently using Numbers but I've run into a slight problem.
In the last row I use a fomula =Max(SalesDate). The result is something like Jan 2, 2014.
On another page I have a fomula as ="Sales as of "&Sales::Table 1::A15 (Reference to the field above). The result is Sales as of Jan 2, 2014
However in one last field I use something like ="Balance as of "&Max(Sales::Table 1::A15, Orders::Table 1::A22) And my result is Balance as of 1/2/14 12:00 AM
It bugs me. I hate the time being there mostly. But I wouldn't mind getting the format the same. I can't seem to find some kind of date format function.
Note: The Orders field is EXACTLY like the sales field. I even have an 'Orders as of Dec 17, 2013' field which shows the date just fine.
In the last row I use a fomula =Max(SalesDate). The result is something like Jan 2, 2014.
On another page I have a fomula as ="Sales as of "&Sales::Table 1::A15 (Reference to the field above). The result is Sales as of Jan 2, 2014
However in one last field I use something like ="Balance as of "&Max(Sales::Table 1::A15, Orders::Table 1::A22) And my result is Balance as of 1/2/14 12:00 AM
It bugs me. I hate the time being there mostly. But I wouldn't mind getting the format the same. I can't seem to find some kind of date format function.
Note: The Orders field is EXACTLY like the sales field. I even have an 'Orders as of Dec 17, 2013' field which shows the date just fine.