Comparing Dates

[tmumaw]

Question for everyone.  I have a customer master table and a billing table.  I need to compare a date from the customer master with a date from the billing table.  Any ideas?

[Gysbert_Wassenaar · Accepted solution]

You can use an if statement to compare them: If( [CalendarDate] = [BillingTableDate], this , that )

[tmumaw]

The dates are on two different tables and I am trying to do this through my load script.

[Gysbert_Wassenaar]

Then you first have to join the two tables into one table.