This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Please help me with this expression

Posted on 05-07-2022 12:01 AM
chiukim
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

chiukim_0-1651905284945.png

i want to express [date_gl] is greater than or equal to 01/01/

Solved Solved
0 2 71
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 2
Platinum 2
Reply posted on --/--/---- --:-- AM

Please text string created with CONACATENATE() with DATE as shown below.

[date_gl]>=DATE(CONCATENATE("01/01/",YEAR(TODAY())-1))

View solution in original post

Jump to Solution
2 REPLIES 2

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 2
Platinum 2
Reply posted on --/--/---- --:-- AM

Please text string created with CONACATENATE() with DATE as shown below.

[date_gl]>=DATE(CONCATENATE("01/01/",YEAR(TODAY())-1))

Jump to Solution

Posted on --/--/---- --:-- AM
chiukim
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

Thanks alot.

Jump to Solution
Top Labels in this Space