Posted: Mon Sep 12, 2005 2:54 am
[quote="richdhan"]Hi Nripendra Chand,
Use the following conversion. You should be through.
Trim(Field(DecimalToString(INPUT_COLUMN),".",1))
HTH
--Rich[/quote]
Hi Nripendra,
Also after doing the above conversion don't use any derivation in your StringtoDate function, just use it StringtoDate(Field(DecimalToString(INPUT_COLUMN),".",1),%yyyy%mm%dd). You will finally get the output date in %yyyy-%mm-%dd format.
Regards
dsusr
Use the following conversion. You should be through.
Trim(Field(DecimalToString(INPUT_COLUMN),".",1))
HTH
--Rich[/quote]
Hi Nripendra,
Also after doing the above conversion don't use any derivation in your StringtoDate function, just use it StringtoDate(Field(DecimalToString(INPUT_COLUMN),".",1),%yyyy%mm%dd). You will finally get the output date in %yyyy-%mm-%dd format.
Regards
dsusr