Parsedate with concat

Q&A
, ,
1

concat(parseDate(substring(toString(sum(DATE2)),1,6),“yyyy-MM-dd”),“-”, parseDate(substring(toString(sum(DATE2)),7,6, “yyyy-MM-dd”))

2

Hello @Siddhi_21 !
Thanks for reaching out.
Can you provide more details and examples on what you’re trying to achieve?
If DATE2 is in Date format, you could addDateTime() instead of Sum(), if the goal is to add a period of time to that.

3

image

the date2 column contain 2022090920221114 date like this start and end date 2022-09-09 and 2022-11-14
i want my result as- 22-sep 09-22-nov-14

4

Is DATE2 format already as Text? If yes, try this please:

concat(
-- start date
toString(
formatDate(parseDate(
concat(left(DATE2,4), '-', substring(left(DATE2,8),5,2), '-',
substring(left(DATE2,8),7,2)), 'yyyy-MM-dd'), 'yyyy-MMM-dd')), 
--
'-', 
-- end date
toString(formatDate(parseDate(
concat(left(right(DATE2,8),4), 
'-', substring(right(DATE2,8),5,2), 
'-',substring(right(DATE2,8),7,2)), 'yyyy-MM-dd'), 'yyyy-MMM-dd'))
--
)

if it’s Number (Int or Decimal), you can try this one:

concat(
-- start date
toString(
formatDate(parseDate(
concat(left(toString(DATE2),4), '-', substring(left(toString(DATE2),8),5,2), '-',
substring(left(toString(DATE2),8),7,2)), 'yyyy-MM-dd'), 'yyyy-MMM-dd')), '-',
-- end date
toString(formatDate(parseDate(
concat(left(right(toString(DATE2),8),4), 
'-', substring(right(toString(DATE2),8),5,2), 
'-',substring(right(toString(DATE2),8),7,2)), 'yyyy-MM-dd'), 'yyyy-MMM-dd'))
)

Hope this works!

1 Like
5

It’s working …now I just want to concante sig Colin to integer with % sign but it showing error can u plz look into it

6

ifelse(
sum({m_s})=4 or sum({m_s})=7,
concat(“(n=” , toString(sum(Integer)), “)”),

sum({m_s})=2,
toString(sum(Integer)),

sum({m_s})=1 or sum({m_s})=3,

concat(
formatDate(parseDate(concat(
substring(toString(sum(DATE2)), 1, 4), ‘-’,
substring(toString(sum(DATE2)), 5, 2), ‘-’,
substring(toString(sum(DATE2)), 7, 2)
), ‘yyyy-MM-dd’), ‘MMM-dd-yyyy’),
’ - ',
formatDate(parseDate(concat(
substring(toString(sum(DATE2)), 9, 4), ‘-’,
substring(toString(sum(DATE2)), 13, 2), ‘-’,
substring(toString(sum(DATE2)), 15, 2)
), ‘yyyy-MM-dd’), ‘MMM-dd-yyyy’)
),
concat(toString(sum(Integer)),“%”)
)

this is the code which i written but anable to add sig(string) colum in last concat can u plz help me with that