Date Conversions

[tlewis]

I am trying to create a date to be used in a formula calculation. The date will be a concatenation of information extracted from another date field and a hard coded year.

How would I concatenate the information below into a date that could be used in the bottom formula?

Concatenate Date

Month = DateTimeMonth([DisDate])

Day = DateTimeDay([DisDate])

Year = 2013

If [TermDate] < "Concatenated Date" Then "Yes" Else "No" Endif

[Thableaus]

Hi @tlewis 

If all of your fields are Strings, it's pretty simple:

Year + "-" +  PadLeft(Month, 2, "0") + "-" + PadLeft(Day, 2, "0")

PadLeft function is to add a 0 to Months and Days < 10.

Cheers

[tlewis]

The fields where not all text. The DOD field is a date format. I think I was able to use your suggestion along with a ToString function to achieve the desired result. Is this acceptable or is there a more straightforward method?

"2013" + "-" +  PadLeft(ToString(DateTimeMonth([DOD]),0), 2, "0") + "-" + PadLeft(ToString(DateTimeDay([DOD]),0), 2, "0")

[Thableaus · Accepted solution]

@tlewis 

Close enough, I'd just get rid of the 0's in the ToString function.

"2013" + "-" +  PadLeft(ToString(DateTimeMonth([DOD])), 2, "0") + "-" + PadLeft(ToString(DateTimeDay([DOD])), 2, "0")

Another way would be using replace function.

Replace([DOD], ToString(DateTimeYear([DOD])), "2013").

This would work as well.

Cheers,