Concatenate Date and Time Fields

[Role21]

I am creating a formula field on my table where I want to merge Date Created (Date/Time) with User ID(text).

The result should look like this:

24/10/2018 Agent1

How do I merge them? Should I convert the Date field to a string? How will I do that? Please help.

 

Thanks in advance.

[JolliBeng]

Hi Role21,

You can use the following formula:

Convert(varchar,Month([@field:Date])) + '/' + Convert(varchar,Day([@field:Date])) + '/' + Convert(varchar,Year([@field:Date])) + Space(1) + [@field:ID]

*Change "Date" to your date field and "ID" to your text field.

 

-JolliBeng

[ManokNaPula]

Hi there! 

 

You can also use this formula if you want it to be shorter: 

CONVERT(VARCHAR(10), [@field:Date], 103) + Space(1) + [@field:ID]

 

I also set the format to dd/mm/yyyy -> that's the format of "103".

 

But you can change it according to the format of the date you wanted: 

 

[NailDyanC]

Just to update and add to this post, you may consider checking the function reference for conversion and other functions you can use: https://howto.caspio.com/function-reference/

[RuisiHansamu]

Hello there, if you were to use another way, I think you can also check out how to concatenate via triggered actions as well. Note that, read and review first the basic information of Triggered actions before trying or implementing this functionality to your end. 

Here is the forum post that you can refer to and the article as well: https://howto.caspio.com/tables-and-views/triggered-actions/