dateadd(sysdate("YYYYMMDD"),-150)
Search found 1794 matches
- July 1st, 2013, 6:14 pm
- Forum: Entry
- Topic: get date on specific countdown or advance
- Replies: 5
- Views: 5562
Re: get date on specific countdown or advance
You could get the date 150 days ago by writing:
- July 1st, 2013, 5:45 pm
- Forum: Entry
- Topic: copy-pasting dictionary from Excel to CSPro
- Replies: 4
- Views: 7068
Re: copy-pasting dictionary from Excel to CSPro
It doesn't matter if your variables are capitalized. If you are copying the Names/Labels to Excel, remember that you can't insert or delete variables within Excel. The number of variables that you paste back in must match exactly the number that are in your dictionary.
- July 1st, 2013, 5:40 pm
- Forum: Other
- Topic: CSPro 4 - 5 compatibility
- Replies: 3
- Views: 6242
Re: CSPro 4 - 5 compatibility
The Unicode Text Converter doesn't take command line arguments at the moment. I can add this functionality if you would like. What task are you trying to accomplish?
- June 16th, 2013, 5:34 pm
- Forum: Feature Requests
- Topic: Option in CsPro 5 to keep ANSI data file as is
- Replies: 3
- Views: 5424
Re: Option in CsPro 5 to keep ANSI data file as is
Some people distribute UTF-8 files without the BOM and then hope that the software package can identify whether or not the file is UTF-8 or ANSI, but this is not an accurate solution 100% of the time. Also, say you have a 1.3 gigabyte data file, which is a possibility in CSPro. To check whether or n...
- June 11th, 2013, 7:25 pm
- Forum: Tabulation
- Topic: Exporting Field Notes to stata
- Replies: 2
- Views: 6451
Re: Exporting Field Notes to stata
How long are your strings? I don't have Stata on the current laptop I'm using so I can't test this, but I'm guessing that this is a Stata problem, not a CSPro problem. I tested exporting a 999 character string, and my Stata.dct file has the following code: infix dictionary using "C:\Users\Inset...
- June 11th, 2013, 4:51 pm
- Forum: Entry
- Topic: Why does some ROSTERs show a error message?
- Replies: 3
- Views: 4548
Re: Why does some ROSTERs show a error message?
We can better help diagnose your problem if you include your application on this forum and tell us how you can recreate this problem. From the error message it seems that you have an advance or move statement that is trying to go to an occurrence that does not exist. Are you using repeating subitems...
- June 11th, 2013, 4:43 pm
- Forum: Entry
- Topic: sub_dictionnary
- Replies: 3
- Views: 4919
Re: sub_dictionnary
As Arshad mentioned, the seek function may be useful to you. You can use that, or simply a do/while loop, to search for the eligible people in the household for which you want to enter data. You can either have a one-to-one correspondence for INDIVIDUAL_FRM and the household roster, in which case yo...
- June 11th, 2013, 1:00 pm
- Forum: Entry
- Topic: copy-pasting dictionary from Excel to CSPro
- Replies: 4
- Views: 7068
Re: copy-pasting dictionary from Excel to CSPro
When you paste it in you have to be careful to follow the format that exists when the value sets are copied to the clipboard. For instance, each value set much only be separated by one row in the Excel file for them to be copied over properly. I suggest that you copy them to the clipboard and paste ...
- June 11th, 2013, 10:09 am
- Forum: Entry
- Topic: Make ID unique
- Replies: 1
- Views: 2397
Re: Make ID unique
Can you clarify your question? Your code appears to add several numbers to the beginning of MAHO. You might consider writing your code like this, without all of the range checks: $ = tonumber ( maketext ( "%d%d%d%03d" ,matinh,mahuyen,maxa,$)); What is your concern with making the values un...
- June 11th, 2013, 9:45 am
- Forum: Entry
- Topic: Cspro import data
- Replies: 6
- Views: 6395
Re: Cspro import data
You have to follow the instructions that Arshad posted to convert the file from Excel format to a space-formatted text file. Then you must create a CSPro dictionary that describes that file. After that you can use in CSPro the data that was previously in Excel format.