Gareth Horton
July 12th, 2002, 01:19 PM
Hi,
You can set the date format by clicking Options, then input. Regarding putting two fields together (concatenate), then you simply make a calculated field, adding the two together. This is the syntax (assuming your field names are field_a and field_b): 'field_a+field_b' - note that the fields should be character fields - if you do it with numeric fields, the numbers will simply be added together
Enrique C. Salinas wrote:
> Hello,
>
> I'm just starting to use monarch v4.0 for some data processing, and I have problems extracting date fields because the format we work here is different from the US format. Is there any way to set another format like MM/DD/YY?. Another issue is that it is very common for the kind of data I managed to put two different sources in only one field to be able to automate some process, Is there any way to extract data from two sources in the same report and put them together in the same field?.
>
> Enrique C. Salinas
> Planner
> FINCON
> Citigroup.
>
You can set the date format by clicking Options, then input. Regarding putting two fields together (concatenate), then you simply make a calculated field, adding the two together. This is the syntax (assuming your field names are field_a and field_b): 'field_a+field_b' - note that the fields should be character fields - if you do it with numeric fields, the numbers will simply be added together
Enrique C. Salinas wrote:
> Hello,
>
> I'm just starting to use monarch v4.0 for some data processing, and I have problems extracting date fields because the format we work here is different from the US format. Is there any way to set another format like MM/DD/YY?. Another issue is that it is very common for the kind of data I managed to put two different sources in only one field to be able to automate some process, Is there any way to extract data from two sources in the same report and put them together in the same field?.
>
> Enrique C. Salinas
> Planner
> FINCON
> Citigroup.
>