Articles in this section

How to work with Date format in SQL: Set command

Avatar
Rasmus Jensen
Updated
Follow

The following works:

Code:

SET($[$12.0.DATE]|SQL: SELECT CONVERT(VARCHAR(10), GETDATE(), 120))

So this should also work:

Code:

Set ($[$12.0.DATE]|SQL: SELECT CONVERT(VARCHAR(10), DateAdd(DD,30,GETDATE()),120));

 

The main reason is that the date has to be in format YYYY-MM-DD


Related articles

Comments

2 comments

Sort by Date Votes
  • Avatar
    Yaremi Miranda Lopez

    HANA:

    @STORE1 = SQL(SELECT TO_VARCHAR(T0."DocDueDate", 'yyyy-mm-dd') FROM "ORDR" T0 WHERE T0."DocNum" = 972);
    SET($[$12.0.DATE]|@STORE1);

    0
    Comment actions Permalink
  • Avatar
    Lauren Downs

    Hi,

    I need the below to say IF ($[$BOYX_5.0.0]  > yesterday:

    What is the correct logic please?

    0
    Comment actions Permalink

Please sign in to leave a comment.