Date Extraction

3 posts / 0 new
Last post
ElaP
Offline
Joined: 03/30/2022 - 04:21
Date Extraction

I would like to ask the group for some help.
I have a very large table and I want to make an extraction of the most recent records. 
For example :
Vardate >= 01022023 
Vardate has an 8 digits.
Thanks

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Is Vardata in a IDEA date format?  If not double click in the data area to bring up the field manipulation dialog.  Then select your Vardate field.

In the type click on it and change the type to date and enter the mask in the Parameter, in my example it would be YYYYMMDD in your case it would be DDMMYYYY or MMDDYYYY depending if it is month / day or day / month.

Now that it is in date format you can use your calculation.  So in my example if I am looking for anything after Jan 01, 2020 I would do something like this:

DATE >= "20220101"

Remember IDEA date format is in YYYYMMDD even if it looks something different on the screen.  So my result would be.

ElaP
Offline
Joined: 03/30/2022 - 04:21

Thanks a lot Brian!