Help With Date

[prees959]

Hi,

I am joining two tables, TableA and TableB, and need to create a single date for all records.  This data field also needs to join onto my master calendar:

Im trying to use this expression:

if(IsNull(DateA),date(DateB,'DD/MM/YYYY'),DateA) as DATE,

But this doesn't link to my master calendar

But if I just use ;

DateA as DATE

Then these only those records from Table A link to my master calendar.

Can anyone advise please?

Phil.

[swuehl · Accepted solution]

Is DateB maybe a timestamp?

Then use

if(IsNull(DateA),date(floor(DateB),'DD/MM/YYYY'),DateA) as DATE,

[prees959]

Perfect Thank you!