How to work with Date format in SQL: Set command

Updated June 03, 2020 21:27

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

Comments

3 comments

Yaremi Miranda Lopez October 13, 2017 12:35

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
Lauren Downs September 26, 2018 15:50

Hi,

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

What is the correct logic please?

0

Comment actions Permalink
Dustin Bellew June 03, 2020 21:27

IF ($[$BOYX_5.0.0] > getdate() -1

0

Comment actions Permalink

Please sign in to leave a comment.