Date_diff of two string Attributes

Gopal_Desai
Gopal_Desai New Altair Community Member
edited November 2024 in Community Q&A

Hello everyone,

i have one Table (as you can see in photo). i would like to calculate Date_diff, if wert (Column) is equal to 0 then timestamp (Column)- timestamp-1 (Column). But problem is column timestamp and timestamp-1 are nominal (String). so i can not able to substract this two columns with Date_diff function. If anyone know could you please help me out?

Thank you

Best Regards,

Gopal 


Tagged:

Best Answer

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓
    Hi,
    Likely you want to use Nominal to Date operator or parse_date function first before doing date_diff.
    Best,
    martin

Answers

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓
    Hi,
    Likely you want to use Nominal to Date operator or parse_date function first before doing date_diff.
    Best,
    martin

Categories