Welcome, Guest. Please Login or Register.
eccoMAGIC Forums
03/29/24 at 00:13:59
News: Welcome to the eccoMAGIC forum.
Home Help Search Login Register


Pages: 1
Send Topic Print
  Rating
Rate:
Rating:
Rating: 0.00
Votes: 0

5
4
3
2
1












5
4
3
2
1


1


2


3


4


5


6


7


8


9


10

Get active date (even if is a recurring date...) (Popularity: 4167 )
Admin
Administrator
*****


I love Ecco!

Posts: 134
Show the link to this post Get active date (even if is a recurring date...)
02/12/17 at 16:32:33
 

 
Code:
 iff(GNRD(Date_Folder), iff(!GPRD(Date_Folder) OR GPRD(Date_Folder) < [Done] ,GNRD(Date_Folder),GPRD(Date_Folder)) , [Date_Folder])  


 
 
will return the active date of the Date_Folder even if the date is a recurring date.
 
If the date_folder uses unusual characters,  you can put in quotes,  such as:  GNRD("Odd Date Folder Name !()")
 
Back to top
 
 

The Administrator.
WWW   IP Logged
Pages: 1
Send Topic Print