|
2021년 1월부터 기존 파일 형식을 더 이상 사용할 수 없습니다. 기존 파일을 전환하거나 PDF를 다운로드할 수 있습니다. 자세히 알아보기

Pipelines

답변함
데모 요청하기

Hi

I'm trying to add a date column in my data by using pipelines. The preview result i'm getting is 46002 which is apparently an excel serial number. I have selected the below parameters including the data type and the format but it's still not showing correctly can anyone please advise?

data type - date

format - dd-mm-yyyy

formula - I have picked from the dynamic options (date)

thanks

 

0

댓글

댓글 3개

날짜 투표수
  • Wade Hays

    Hi Chelsea,

    If you wrap the "date" variable in a TEXT formula, you can convert the Excel serial number to whatever date format you need.

    text({{data.system.date}},"MM-dd-yyyy")

     

    0
  • Chelsea Carter

    Thank you!! Are you able to give me a formula that will work in pipelines to get the system date and if the date is before the 20th then give me current month if the date is after the 20th then give me the following month. For example if the pipeline was run today (23rd Dec) I would want my formula to bring back January.

     

    thanks

    0
  • Jeff Hickey

    Hi Chelsea Carter,

    You can update the formula to look like the below formula. The below formula will return the current month if the day is 1 to 20, or the next month if the day is 21 to 31. It does this in the section "DAY({{data.system.date}}) >= 21". If this is true, the formula adds 1 to the month.

    TEXT(
        DATE(
            YEAR({{data.system.date}}),
            MONTH({{data.system.date}}) + IF(DAY({{data.system.date}}) >= 21, 1, 0),
            1
        ),
    "MMMM")

    Thanks,
    Jeff

    0

댓글을 남기려면 로그인하세요.