FinTheHuman Posted February 18, 2019 Report Share Posted February 18, 2019 Hello everyone, I'm using a TASK to concatenate my fields in my table: However, my problem is when I include my Date DataType field, it always adds this "00:00:00 (looks like a time perhaps)" in the Date field. How can I removed this ? Thank you for the answers. Quote Link to comment Share on other sites More sharing options...
0 Aether Posted February 18, 2019 Report Share Posted February 18, 2019 Hey @FinTheHuman, I have a similar problem before, what I did is just get the DATEPART to eliminate the time value. I hope this helps ~WatashiwaJin~ Quote Link to comment Share on other sites More sharing options...
0 IamGroot Posted February 18, 2019 Report Share Posted February 18, 2019 Hi @FinTheHuman, WatashiwaJin provided was helpful, but what I suggest is to use a formula instead. You can try to use this formula code: [@field:Grade_ID] + Space(1) + [@field:Descript] + Space(1) + CONVERT(VARCHAR(10), [@field:Date_Recieved], 101) Let me know if you have further question about this. -IamGroot Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted March 4, 2019 Report Share Posted March 4, 2019 If from text functions you get "in XXX get first XXX Characters" and add it to the date field: http://joxi.ru/YmEWZbjswM9E8A You will get this format : 23 - test from (Jun 9 2010) Quote Link to comment Share on other sites More sharing options...
Question
FinTheHuman
Hello everyone,
I'm using a TASK to concatenate my fields in my table:
However, my problem is when I include my Date DataType field, it always adds this "00:00:00 (looks like a time perhaps)" in the Date field.
How can I removed this ?
Thank you for the answers.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.