Calendar

[kevbrown]

I'm creating an app that is bring in around 20 tables all with different date fields, for example, referral date, admission date, contact date, closed date, bed day date.  Some of these are just dates some are date time fields.  How best should i create a master calendar with these fields? My current calendar doesn't seem to want to work due to the date-time fields

[marcus_sommer]

You could separate dates and times per:

date(floor([date-time])) as Date,

time(frac([date-time])) as Time

and you might need Canonical Date to consolidate the various dates. More informations could you find here: How to use - Master-Calendar and Date-Values.

- Marcus

[kevbrown · Accepted solution]

Date# seems to have done the trick