forward quote between month and year

[#1]

Hi,

In the label part of one expression; i have to display Ex:Jul’15.

in label i have coded like:  =month($(vjuly))&'''&'15'

but i could not get.

Pls help me dudes...

[MayilVahanan · Accepted solution]

Hi

Try like this

=month(Today())&Chr(39)&Right(Year(Today()),2)

[sasiparupudi1]

replace(Date(Today(),'MMM YY'),' ',chr(39))

[#4]

hey mayil, i wanna fetch data from excel- which is in shared location.

in edit script;

i have wrritten;

LET Sharepoint_Path ='$(Include=$(include_path)Connections\connect_to_digital_SP.txt)';

and at loading; i used like:

load XXXX

FROM

[$(Sharepoint_Path)Digital%20Monthly%20Plan.xlsx]

(ooxml, embedded labels, table is Deposits);

it is throwing error...can u tell how to proceed?

[#5]

wow nice way

[MayilVahanan]

Hi

Did you check the value in this "Sharepoint_Path ' is right or wrong?

[#7]

s that is correct.

[MayilVahanan]

Hi

Could you please check the file name. And also check the error message in log file.

Setting -> Document properties -> Generate Log file.