... " A_Hour ":" A_Min " on " A_DDDD ", " A_DD " " A_MMMM " " A_YYYY "`n`nAnd it's time for that gentle reminder..."
Message1:="In total...`nYou have " ThisManyWeeksMessage " left at BU.`n`n ...
... "dd/MM/yyyy HH:mm:ss")
-- yields 11/02/2014 11:21:32
Sounds good, where's the problem?
The problem
Putting the date in an IIF (if-then-else) statement displays "#Error". You should get errors ...
... conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.