Automate

Hi Folks,

My simple query works well except that the following date columns I'm unable to extract in mm/dd/yyyy format . Could someone please guide me to setup the transformation rules?


Thank you for your time.
Regards,
Subbu Manjappa
SAP Analyst

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735
------------------------------

Hi Manjappa 

Glad you script is working.  You could try two things that I know of:

(1) in Excel, format the column to be the date format you want and re-run the query
If that doesn't work
(2) use an Excel formula =TEXT(I2,"mm/dd/yyyy") specify another column to create the value, like BI2, and check the box to Transform Original Mapping

Hope that helps,
Sigrid



------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Original Message:
Sent: 06-14-2022 21:37
From: Manjappa Subramhanya
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Folks,

My simple query works well except that the following date columns I'm unable to extract in mm/dd/yyyy format . Could someone please guide me to setup the transformation rules?


Thank you for your time.
Regards,
Subbu Manjappa
SAP Analyst

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735
------------------------------

Hi Sigrid,

I did try the option #1 - didn't work - however, the option #2 would  work but would also add extra columns - not desirable  and  the same issue with MARA table too (any date column).

Thank you for your tips - will use it where possible.

Thank You
Subbu Manjappa


​​

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735
------------------------------

Original Message:
Sent: 06-15-2022 09:48
From: Sigrid Kok
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Manjappa 

Glad you script is working.  You could try two things that I know of:

(1) in Excel, format the column to be the date format you want and re-run the query
If that doesn't work
(2) use an Excel formula =TEXT(I2,"mm/dd/yyyy") specify another column to create the value, like BI2, and check the box to Transform Original Mapping

Hope that helps,
Sigrid



------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 06-14-2022 21:37
From: Manjappa Subramhanya
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Folks,

My simple query works well except that the following date columns I'm unable to extract in mm/dd/yyyy format . Could someone please guide me to setup the transformation rules?


Thank you for your time.
Regards,
Subbu Manjappa
SAP Analyst

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735
------------------------------

Hi Manjappa 
If you check the Transform Original Mapping, you will only have 1 column, not 2.

FYI
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Original Message:
Sent: 06-16-2022 01:12
From: Manjappa Subramhanya
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Sigrid,

I did try the option #1 - didn't work - however, the option #2 would  work but would also add extra columns - not desirable  and  the same issue with MARA table too (any date column).

Thank you for your tips - will use it where possible.

Thank You
Subbu Manjappa


​​

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735

Original Message:
Sent: 06-15-2022 09:48
From: Sigrid Kok
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Manjappa 

Glad you script is working.  You could try two things that I know of:

(1) in Excel, format the column to be the date format you want and re-run the query
If that doesn't work
(2) use an Excel formula =TEXT(I2,"mm/dd/yyyy") specify another column to create the value, like BI2, and check the box to Transform Original Mapping

Hope that helps,
Sigrid



------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 06-14-2022 21:37
From: Manjappa Subramhanya
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Folks,

My simple query works well except that the following date columns I'm unable to extract in mm/dd/yyyy format . Could someone please guide me to setup the transformation rules?


Thank you for your time.
Regards,
Subbu Manjappa
SAP Analyst

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735
------------------------------

Okay, now the query isn't returning anything:


Regards,
Subbu Manjappa.

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735
------------------------------

Original Message:
Sent: 06-16-2022 10:03
From: Sigrid Kok
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Manjappa 
If you check the Transform Original Mapping, you will only have 1 column, not 2.

FYI
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 06-16-2022 01:12
From: Manjappa Subramhanya
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Sigrid,

I did try the option #1 - didn't work - however, the option #2 would  work but would also add extra columns - not desirable  and  the same issue with MARA table too (any date column).

Thank you for your tips - will use it where possible.

Thank You
Subbu Manjappa


​​

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735

Original Message:
Sent: 06-15-2022 09:48
From: Sigrid Kok
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Manjappa 

Glad you script is working.  You could try two things that I know of:

(1) in Excel, format the column to be the date format you want and re-run the query
If that doesn't work
(2) use an Excel formula =TEXT(I2,"mm/dd/yyyy") specify another column to create the value, like BI2, and check the box to Transform Original Mapping

Hope that helps,
Sigrid



------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 06-14-2022 21:37
From: Manjappa Subramhanya
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Folks,

My simple query works well except that the following date columns I'm unable to extract in mm/dd/yyyy format . Could someone please guide me to setup the transformation rules?


Thank you for your time.
Regards,
Subbu Manjappa
SAP Analyst

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735
------------------------------

Hi Manjappa ,
The cell to do the work needs to be different

Use BB2 or something like that - it's where the formula is evaluated but not displayed.  

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Original Message:
Sent: 06-16-2022 11:42
From: Manjappa Subramhanya
Subject: Date Formatting Challenges for a SAP Info Records Query

Okay, now the query isn't returning anything:


Regards,
Subbu Manjappa.

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735

Original Message:
Sent: 06-16-2022 10:03
From: Sigrid Kok
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Manjappa 
If you check the Transform Original Mapping, you will only have 1 column, not 2.

FYI
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 06-16-2022 01:12
From: Manjappa Subramhanya
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Sigrid,

I did try the option #1 - didn't work - however, the option #2 would  work but would also add extra columns - not desirable  and  the same issue with MARA table too (any date column).

Thank you for your tips - will use it where possible.

Thank You
Subbu Manjappa


​​

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735

Original Message:
Sent: 06-15-2022 09:48
From: Sigrid Kok
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Manjappa 

Glad you script is working.  You could try two things that I know of:

(1) in Excel, format the column to be the date format you want and re-run the query
If that doesn't work
(2) use an Excel formula =TEXT(I2,"mm/dd/yyyy") specify another column to create the value, like BI2, and check the box to Transform Original Mapping

Hope that helps,
Sigrid



------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 06-14-2022 21:37
From: Manjappa Subramhanya
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Folks,

My simple query works well except that the following date columns I'm unable to extract in mm/dd/yyyy format . Could someone please guide me to setup the transformation rules?


Thank you for your time.
Regards,
Subbu Manjappa
SAP Analyst

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735
------------------------------

Thank you Sigrid,

it worked - there was no unnecessary display too - appreciated.

Regards,
Subbu Manjappa.

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735
------------------------------

Original Message:
Sent: 06-16-2022 11:48
From: Sigrid Kok
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Manjappa ,
The cell to do the work needs to be different

Use BB2 or something like that - it's where the formula is evaluated but not displayed.  

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 06-16-2022 11:42
From: Manjappa Subramhanya
Subject: Date Formatting Challenges for a SAP Info Records Query

Okay, now the query isn't returning anything:


Regards,
Subbu Manjappa.

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735

Original Message:
Sent: 06-16-2022 10:03
From: Sigrid Kok
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Manjappa 
If you check the Transform Original Mapping, you will only have 1 column, not 2.

FYI
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 06-16-2022 01:12
From: Manjappa Subramhanya
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Sigrid,

I did try the option #1 - didn't work - however, the option #2 would  work but would also add extra columns - not desirable  and  the same issue with MARA table too (any date column).

Thank you for your tips - will use it where possible.

Thank You
Subbu Manjappa


​​

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735

Original Message:
Sent: 06-15-2022 09:48
From: Sigrid Kok
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Manjappa 

Glad you script is working.  You could try two things that I know of:

(1) in Excel, format the column to be the date format you want and re-run the query
If that doesn't work
(2) use an Excel formula =TEXT(I2,"mm/dd/yyyy") specify another column to create the value, like BI2, and check the box to Transform Original Mapping

Hope that helps,
Sigrid



------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 06-14-2022 21:37
From: Manjappa Subramhanya
Subject: Date Formatting Challenges for a SAP Info Records Query

Hi Folks,

My simple query works well except that the following date columns I'm unable to extract in mm/dd/yyyy format . Could someone please guide me to setup the transformation rules?


Thank you for your time.
Regards,
Subbu Manjappa
SAP Analyst

------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735
------------------------------