One field changing as change another 1 or second field of same table

[shabirAhmad]

Dear Experts,

As shown in above images in these two images i want to change the date/time to only date. The column Date showing Date/time both as i change the date/time to only date the batch number sunndenly change to "xxxx".Note these both fields are from same table as i have 6 or 7 tables in my datasource using SQL SERVER View.My Question is, why these batch number is converting to "xxxx". which i don't want!

Best Regards,

Shabir Ahmad

[shabirAhmad · Accepted solution]

Thanks for your reply, as i am begginer i used to change the date from transform tab which was giving wrong result. i did using change Type and it worked out the issue.

Best Regards,

Shabir Ahmad

[some_bih]

Hi @shabirAhmad from your picture, only, I noticed:

- that batch number with XXXX (left side) is date from future while on right side it is all actual dates

-expire date columns  are not complete equal in format view

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

[shabirAhmad]

some_bih,

You are right. Expiry is futere date of inventory why when i changed expiry date format it automatically changed to xxxx cross sign. and how can i fix it.

Best Regards,

Shabir Ahmad

[some_bih]

Hi @shabirAhmad I realy have no idea for xxxx. you should check your definition if something is not retrived (as date is from future) is there some default values. Trace sessions for today tomorrow and check if xxx is gone.