Comments
Sort by recent activity
I know this is old, but posting my answer if anyone is searching this forum. I was able to complete this using a custom SQL Command. This example generates a random date somewhere from 01/01/1951 to 01/01/2001, then encrypts it and returns the bit value. This only returns one value so I set the flag to loop for all rows. DECLARE @dateenc varbinary(128)
SET @dateenc= EncryptByKey(Key_GUID('SymKey'),CONVERT(nvarchar(10),DATEADD(DAY, ABS(CHECKSUM(NEWID()) % 18615), '1950-01-01'))) SELECT @dateencAS dateenc / comments
I know this is old, but posting my answer if anyone is searching this forum.I was able to complete this using a custom SQL Command. This example generates a random date somewhere from 01/01/1951 to...