Home : VDE
Q14390 - INFO: VDE
 VDE returns a flag (1 or 0) that indicates that the data for the variable has been edited, deleted, or forced.


VDE(VarNum,Offset/Date, Edit Type)

VarNum: The variable number to get text value for.

Offset/Date: If the field is numeric it is assumed to be the offset and is defined as the offset from the start date of the report. For example, for a daily variable if the start date is 1/1/2016 and the offset is 1, the value from 1/1/2016 will be returned. If the offset is 2, the value from 1/2/2016 will be returned and so forth. For daily detail variables 1 returns the first data slot since the start date, a 2 the second data slot for the variable type, etc...  If the field is a date in quotes or a cell reference to a cell containing a date the value for the date will be returned.

Edit Type:  Sets what type of edits should be flagged: 

Edit Type Description  
1 Value was edited or deleted
2 Value was deleted at any time
3 Last Audit record is a delete
4 Value was edited at any time
5 Value was Forced


Works with Daily and Daily Detail variables.


=VDE(2,1,1) returns if variable 2 was edited or deleted for the first data slot.

=VDE(12,B5,5) returns a 1 if variable 12 was Forced for the date in cell B5.

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?


Tell us why you rated the content this way. (optional)
Approved Comments...
No user comments available for this article.
Created on 9/20/2016 12:17 PM.
Last Modified on 3/23/2017 1:58 PM.
Last Modified by Scott Dorner.
Article has been viewed 2669 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article