SQL converting dates in macro

Answered

David Erkelius

• March 20, 2018 15:47

Hi, 

I would like to compare two dates in stringformat. One is from GETDATE:

@STORE52 = SQL(SELECT CONVERT(VARCHAR(10), GETDATE() +2, 120));

Works fine.

the other is from DocDueDate:

@STORE14 = SQL('SELECT TOP 1 T1.[DocDueDate] FROM OCRD T0 INNER JOIN ORDR T1 ON T0.CardCode = T1.CardCode WHERE T1.[DocStatus] = 'O' AND T0.CardCode = $[$4.0.0] ORDER BY T1.[DocDueDate] DESC')

Works fine

 

Then i want to convert @STORE14 to textstring, but I cant get it to work

@STORE60 =SQL('SELECT CONVERT(varchar(10), @STORE14, 120') 

Doesnt work. What have I made wrong?

Best regards

/David 

 

Vote

0

• 

  John Slaats

  • March 23, 2018 08:13

  Hi,

  I'm a newbe with B1Up but can it be that there is a parenthesis missing in the @STORE60 query?

  Also I understand that the @STORE variables are of type nvarchar.
  So your @STORE14 is already converted.

  If you need a specific conversion (date_style) you put it in the first query.

  Regards,
  John
• 

  Yaremi Miranda Lopez

  • March 26, 2018 18:37

  Hello John,

  Thank you so much for your reply, you're correct! =)

Please sign in to leave a comment.