Please help me with this expression

chiukim_0-1651905284945.png

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

Solved Solved
0 2 55
1 ACCEPTED SOLUTION

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

2 REPLIES 2

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

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

Thanks alot.

Top Labels in this Space