ETL Date Format

Hi Mike

I am trying to set up a date as a variable that can be entered once and then used by the export packages.

In the screen shot I have modified an existing variable that works fine when the “date” is set up as “now” to get the current date.

We have a requirement to be able to enter a specific past date I have replaced “now” with a specific date but the package fails when it tries to resolve the date.

I could not find anything specific in the manual regarding the format for the syntax when working with actual dates

I have attached the log file of a run trying to use the date in this form and also a copy of the Repository back-up

Your comments on the format would be appreciated –

Regards,
B

I do not think that you actually need FormatDateTime Function here
use SetVariable('extract_date','01/07/2010') instead.

Peter