DATE RETREIVAL

[Anonymous]

Hi , i need to create a date field with the following existing fields: i do not have a date field in the model.

File base name :  2010data and sheetname is Jan :  how can i make use of MakeDate function to create a date field of the format DD/MM/YYYY (01/01/2010).    Can anyone suggest an idea please

Regards

[YoussefBelloum]

Hi,

what do you mean by Sheetname is Jan ?

do you want to create new date field on the script ?

[tresB · Accepted solution]

Try like:

Load

          MakeDate(Left([File base name],4), Num(Month(Date#(Sheetname, 'MMM')))) as Date

Or,

          Date(Date#(Left([File base name],4)&Sheetname, 'YYYYMMM')) as Date

[Anonymous]

Hi Youssef,

yes , i need to create a new date field in the script. I have FileBaseName field as 2010data   and SheetName field as Jan, Feb ,Mar ...so on ....

Thanks for your reply Youssef , i managed to sort it out.

Regards