Date Change

[vmjan02]

Not sure as it is not converting the date,
the data is there, the code is not convert mm/dd/yyyy to dd-mm-yyyy

the problem is if till 12 day of any month the date come as mm/dd/yyyy and as it 13 day of any month then the input file comes as dd-mm-yyyy

so need a code that will fix the to dd-mm-yyyy always.

Sub datachange()

Application.Wait (Now + TimeValue("0:00:02"))
  Range("B2:B80000").TextToColumns Destination:=Range("B2"), DataType:=xlDelimited, _
        TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
        Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
        :=Array(1, 4), TrailingMinusNumbers:=False
  Range("B2:B80000").NumberFormat = "dd-mm-yyyy"

End Sub

Book3
	B
1	CREADTED_DATE
2	2/11/2023
3	31-10-2023
4	31-10-2023
5	31-10-2023
6	31-10-2023
7	1/11/2023
8	1/11/2023
9	1/11/2023
10	1/11/2023
11	1/11/2023
12	1/11/2023
13	2/11/2023
14	31-10-2023
15	31-10-2023
16	31-10-2023
17	31-10-2023
18	31-10-2023
19	31-10-2023
20	31-10-2023
21	31-10-2023
22	31-10-2023
23	1/11/2023
Sheet1

 

[MARK858]

after running this the result, and orignial data i have already share on my 1 st post in xl2bb

I want to see it without XL2BB possibly displaying it differently

 

[MARK858]

a

after running this the result, and orignial data i have already share on my 1 st post in xl2bb

WEK	CREADTED_DATE
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​
44​	45230​

That would say it is all the same date?

 

[vmjan02]

That would say it is all the same date?

THIS IS THE entire original data, were date is in dd-mm-yyyy and dd/mm/yyyy(screen shot attached) this need to be in one single format dd-mm-yyyy so dd/mm/yyyy need to be cganged to dd-mm-yyyy.
After running the code from post 9, xl2bb is the result.
I hope i am clear now.

post #9 code

Sub datachange()
Range("B2:B80000").TextToColumns Destination:=Range("B2"), DataType:=xlDelimited, _
        TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
        Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
        :=Array(1, 4), TrailingMinusNumbers:=False
 Range("B2:B80000").NumberFormat = "General"

End Sub

result.

1 Complaint Rawfile.csv
	A	B	C	D	E	F	G	H	I	J	K
5024	44	45230	1-1390280973486	148251090	Internet	No browsing	Technical	Normal	WESTERN	FTTH	Madinah_Province
5025	44	45231	1-1390290039610	148656000	Internet	Browsing intermittent	Technical	Normal	WESTERN	FTTH	Madinah_Province
5026	44	45231	1-1390305091804	148456916	Internet	No browsing	Technical	Normal	WESTERN	FTTH	Madinah_Province
5027	44	45231	1-1390323357134	148130944	More than one service affected	OLO ONT Down	Technical	Normal	WEST	FTTH	Madinah_Province
5028	44	45231	1-1390328657581	148470231	Internet	No Internet connection	Technical	Normal	WESTERN	FTTH	Madinah_Province
5029	44	45231	1-1390355053730	148197851	Internet	Slow Browsing	Technical	Normal	MADINAH	FTTH	Madinah_Province
5030	44	45231	1-1390385686961	148407714	E-channel	MySTC IOS LL	Technical	Normal	Western	FTTH	Madinah_Province
5031	44	45231	1-1390385664130	148155594	Internet	Baity Wi-Fi Mesh	Technical	Normal	WESTERN	FTTH	Madinah_Province
5032	44	45231	1-1390427617933	148220287	Internet	No Internet connection	Technical	Normal	WESTERN	FTTH	Madinah_Province
5033	44	45232	1-1390441291577	148316463	Internet	Modem Faulty	Technical	Normal	MADINAH	FTTH	Madinah_Province
5034	44	45232	1-1390447780645	148232122	More than one service affected	Loss of signal	Technical	Normal	WESTERN	FTTH	Madinah_Province
5035	44	45230	1-1390188503225	144216484	Internet	No Internet connection	Technical	Normal	WESTERN	FTTH	Tabuk_Province
5036	44	45230	1-1390194513601	144215062	Internet	Slow Browsing	Technical	Normal	WESTERN	FTTH	Tabuk_Province
5037	44	45230	1-1390226874643	144239868	Internet	No browsing	Technical	Normal	WESTERN	FTTH	Tabuk_Province
5038	44	45230	1-1390254679230	144226012	Internet	No Internet connection	Technical	Normal	WESTERN	FTTH	Tabuk_Province
5039	44	45231	1-1390339245015	144249478	More than one service affected	Loss of signal	Technical	Normal	WESTERN	FTTH	Tabuk_Province
5040	44	45231	1-1390343022620	144229440	Internet	Browsing intermittent	Technical	Normal	WESTERN	FTTH	Tabuk_Province
5041	44	45231	1-1390346066676	144272283	Internet	No Internet connection	Technical	Normal	WESTERN	FTTH	Tabuk_Province
5042	44	45231	1-1390343497582	144243923	Internet	No Internet connection	Technical	Normal	WESTERN	FTTH	Tabuk_Province
5043	44	45231	1-1390375717684	144251608	More than one service affected	Loss of signal	Technical	Normal	WESTERN	FTTH	Tabuk_Province
5044	44	45231	1-1390401517707	144223351	More than one service affected	Loss of signal	Technical	Normal	WESTERN	FTTH	Tabuk_Province
5045	44	45232	1-1390449632338	144225649	More than one service affected	Loss of signal	Technical	Normal	WESTERN	FTTH	Tabuk_Province
5046	44	45230	1-1390149296728	146260695	Internet	No Internet connection	Technical	Normal	EASTERN	FTTH	Jawf_Province
5047	44	45230	1-1390221246348	146220043	More than one service affected	Loss of signal	Technical	Normal	EASTERN	FTTH	Jawf_Province
5048	44	45230	1-1390240296239	146222905	Internet	Slow Browsing	Technical	Normal	North	FTTH	Jawf_Province
5049	44	45230	1-1390263545765	146224295	More than one service affected	All services not working	Technical	Normal	EASTERN	FTTH	Jawf_Province
5050	44	45230	1-1390132752952	146761285	Internet	No Internet connection	Technical	Normal	NORTHERN REGION	FTTH	Northern Borders
5051	44	45230	1-1390155498891	146625727	More than one service affected	All services not working	Technical	Normal	EASTERN	FTTH	Northern Borders
5052	44	45230	1-1390170705999	146630924	Internet	Issue with WIFI Solution	Technical	Normal	EASTERN	FTTH	Northern Borders
5053	44	45230	1-1390197167527	146764693	Internet	OLO ONT Down	Technical	Normal	NORTHERN REGION	FTTH	Northern Borders
5054	44	45230	1-1390210915450	146670183	Internet	Baity Wi-Fi Mesh	Technical	Normal	North	FTTH	Northern Borders
5055	44	45231	1-1390387843103	146627207	More than one service affected	All services not working	Technical	Normal	EASTERN	FTTH	Northern Borders
1 Complaint Rawfile

 

[MARK858]

I changed my computers regional settings to US i.e. mm/dd/yyyy and ran the code in your first post on the data in the first post.
It went from

to

which looks correct to me if the settings are correct to what you stated (the numbers when formatted as General in your last XL2BB are also correct)

 

[vmjan02]

ok let my try that.

 

[MARK858]

I thought you had already tried that?
The code and data is what you posted in post 1 and the settings are what you stated in post 7.

Can't see why you didn't get the same result as me

 

[vmjan02]

I thought you had already tried that?
The code and data is what you posted in post 1 and the settings are what you stated in post 7.

Can't see why you didn't get the same result as me

 

[vmjan02]

Tried ever possible step,
not sure why it is not working. in deed applied this code as well, but the filter is not working correct. I will appricagte your help here to edit and close it.

This will change the date as mm-dd-yyyy

Sub FormatAllNonBlankCellsInNewColumnB()
    Dim LastRow As Long
    Dim ws As Worksheet
    Dim Cell As Range

    ' Define the worksheet where you want to work
    Set ws = ThisWorkbook.Worksheets("RawData") ' Change "Sheet1" to your sheet's name

    ' Insert a column before column B
    ws.Columns("B").Insert
    ws.Columns("B").Insert

    ' Find the last row in the newly inserted column B
   
    LastRow = ws.Cells(ws.Rows.Count, "D").End(xlUp).Row

    ' Loop through all non-blank cells in the newly inserted column B
    For Each Cell In ws.Range("D2:D" & LastRow)
        If Not IsEmpty(Cell.Value) Then
            ' Check if the cell value is a date
            If IsDate(Cell.Value) Then
                ' Format the date and write it to column A (change the format as needed)
                Cell.Offset(0, -1).Value = Format(Cell.Value, "dd-mm-yyyy")
            End If
        End If
    Next Cell

Range("b1").Value = "CREADTED_DATE"
    With Worksheets("RawData")
    With .Range("B2:B" & .Range("C" & .Rows.Count).End(xlUp).Row)
        .Formula = "=TEXT(C2,""dd-mm-yyyy"")"
       ' .Value = .Value
'        .NumberFormat = "mm-dd-yyyy"
     End With
End With

Range("B2:B80000").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False
  
ws.Columns("C:D").Delete

End Sub

I am facing the problem here now it is deleting the entire data as in cell d10 has the vale as 01-11-2023, if this filter part works out then all is perfect.

Sub deletedatedata()

    Dim lRow3 As Long
    Dim lColumn3 As Long
    Dim crit As String

    Sheets("RawData").Select
'   Set criteria
    crit = "<>" & Sheets("Table").Range("D10").Value   'ref screen shot

    lRow3 = Range("A1").End(xlDown).Row
    lColumn3 = Range("A1").End(xlToRight).Column
       
    Range("B1").AutoFilter
    On Error Resume Next
    ActiveSheet.Range("A1:S1" & lRow3).AutoFilter Field:=2, Criteria1:= _
        crit, Operator:=xlAnd

    Range("A1:S" & lRow3).Offset(1, 0).SpecialCells(xlCellTypeVisible).EntireRow.Delete
    Selection.AutoFilter
End Sub

View attachment 101484

Actual rawdata in xl2bb

01-11-2023-CC.csv
	A	B	C	D	E	F	G	H	I	J	K
1	WEK	CREADTED_DATE	SR_NUM	PH_NUMBER	SR_AREA	SR_SUB_AREA	COMPLAINT_TYPE	COMPLAINT_SOURCE	X_STC_REGION	X_STC_TECHNOLOGY	CITC_REGION
2	44	31-10-2023	1-1390237452253	114533684	Internet	Slow Browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
3	44	31-10-2023	1-1390244536459	112332957	Jawwy TV	Remote Faulty	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
4	44	31-10-2023	1-1390246167261	112487262	Jawwy TV	STB Faulty	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
5	44	31-10-2023	1-1390245940667	112490196	Jawwy TV	STB Faulty	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
6	44	31-10-2023	1-1390250532717	112301846	More than one service affected	Telephone& Internet problem	Technical	Normal	CENTER	FTTH	Riyadh_Province
7	44	31-10-2023	1-1390251806517	112361924	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
8	44	31-10-2023	1-1390252259388	112403043	VOIP	Make a Call issue	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
9	44	31-10-2023	1-1390252439245	114226145	Jawwy TV	Interruption in the Video	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
10	44	31-10-2023	1-1390256105781	112227477	Internet	Browsing intermittent	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
11	44	31-10-2023	1-1390257897326	116310407	VOIP	No dial tone	Technical	Normal	CENTER	FTTH	Riyadh_Province
12	44	31-10-2023	1-1390258824237	112354228	More than one service affected	Loss of signal	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
13	44	31-10-2023	1-1390262073505	114028634	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
14	44	31-10-2023	1-1390261535420	112306830	Internet	OLO ONT Down	Technical	Normal	CENTER	FTTH	Riyadh_Province
15	44	31-10-2023	1-1390263001356	112388694	More than one service affected	Loss of signal	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
16	44	31-10-2023	1-1390264085500	114853224	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
17	44	31-10-2023	1-1390263509864	112314795	Jawwy TV	Freezing / Jittering	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
18	44	31-10-2023	1-1390268330823	112427508	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
19	44	31-10-2023	1-1390269390984	112578743	Internet	No Internet connection	Technical	Normal	CENTER	FTTH	Riyadh_Province
20	44	31-10-2023	1-1390269410612	112302132	More than one service affected	Loss of signal	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
21	44	31-10-2023	1-1390269126846	114556352	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
22	44	31-10-2023	1-1390275762429	112416873	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
23	44	31-10-2023	1-1390277091803	114495722	VOIP	No dial tone	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
24	44	1/11/2023	1-1390285606882	112481276	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
25	44	1/11/2023	1-1390294945535	112344307	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
26	44	1/11/2023	1-1390293061973	112785245	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
27	44	1/11/2023	1-1390295583158	112055064	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
28	44	1/11/2023	1-1390295362265	112277180	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
29	44	1/11/2023	1-1390295165799	114850852	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
30	44	1/11/2023	1-1390293062914	114239633	More than one service affected	Loss of signal	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
31	44	1/11/2023	1-1390296714514	114780763	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
32	44	1/11/2023	1-1390297499134	112750793	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
33	44	1/11/2023	1-1390293091903	112293205	Internet	Baity Wi-Fi Mesh	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
34	44	1/11/2023	1-1390300146077	114002019	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
35	44	1/11/2023	1-1390299536501	112317131	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
36	44	1/11/2023	1-1390305091624	112316870	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
37	44	1/11/2023	1-1390303638599	112544789	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
38	44	1/11/2023	1-1390307765106	114765513	Internet	Speed Upgrade	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
39	44	1/11/2023	1-1390308506394	112225247	More than one service affected	Loss of signal	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
40	44	1/11/2023	1-1390312320047	114800794	Jawwy TV	Remote Faulty	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
41	44	1/11/2023	1-1390316584704	112783874	Internet	No browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
42	44	1/11/2023	1-1390318496759	112476714	Internet	Browsing intermittent	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
43	44	1/11/2023	1-1390321636967	114389960	More than one service affected	Loss of signal	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
44	44	1/11/2023	1-1390322903294	114024546	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
45	44	1/11/2023	1-1390322904565	114315974	More than one service affected	Loss of signal	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
46	44	1/11/2023	1-1390323853547	114005124	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
47	44	1/11/2023	1-1390323666500	114419298	VOIP	No dial tone	Technical	Normal	Central	FTTH	Riyadh_Province
48	44	1/11/2023	1-1390325985408	112401535	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
49	44	1/11/2023	1-1390326514069	112571007	Internet	Modem Faulty	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
50	44	1/11/2023	1-1390327112234	112052264	Internet	No Internet connection	Technical	Normal	Center	FTTH	Riyadh_Province
51	44	1/11/2023	1-1390329719926	114750061	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
52	44	1/11/2023	1-1390330541430	114200027	More than one service affected	OLO ONT Down	Technical	Normal	Center	FTTH	Riyadh_Province
53	44	1/11/2023	1-1390333507082	112251178	Internet	Slow Browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
54	44	1/11/2023	1-1390333334916	112005537	Internet	OLO ONT Down	Technical	Normal	Central	FTTH	Riyadh_Province
55	44	1/11/2023	1-1390333518174	112475180	More than one service affected	All services not working	Technical	Normal	CENTER	FTTH	Riyadh_Province
56	44	1/11/2023	1-1390334555825	114834761	Internet	No browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
57	44	1/11/2023	1-1390334556793	112176104	Internet	Baity Wi-Fi Mesh	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
58	44	1/11/2023	1-1390335865165	112442329	Internet	Browsing intermittent	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
59	44	1/11/2023	1-1390334567395	112180552	More than one service affected	Loss of signal	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
60	44	1/11/2023	1-1390337326816	112223670	Internet	Slow Browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
61	44	1/11/2023	1-1390337334751	112135225	Internet	No browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
62	44	1/11/2023	1-1390335631976	114022521	More than one service affected	OLO ONT Down	Technical	Normal	Central	FTTH	Riyadh_Province
63	44	1/11/2023	1-1390337843007	114069751	Internet	No browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
64	44	1/11/2023	1-1390337987448	112204337	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
65	44	1/11/2023	1-1390317763205	114035736	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
66	44	1/11/2023	1-1390338656153	112414571	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
67	44	1/11/2023	1-1390339208838	172219076	Internet	No browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
68	44	1/11/2023	1-1390339903742	112472956	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
69	44	1/11/2023	1-1390339997962	115622915	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
70	44	1/11/2023	1-1390340802950	114082242	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
71	44	1/11/2023	1-1390340072214	112496970	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
72	44	1/11/2023	1-1390330176635	112486007	More than one service affected	Loss of signal	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
73	44	1/11/2023	1-1390339748709	112097241	More than one service affected	Loss of signal	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
74	44	1/11/2023	1-1390341316751	112307590	Jawwy TV	STB Faulty	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
75	44	1/11/2023	1-1390341370804	112254084	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
76	44	1/11/2023	1-1390342257330	112132977	Internet	Slow Browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
77	44	1/11/2023	1-1390342150886	114082931	Internet	Slow Browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
78	44	1/11/2023	1-1390342513180	114454887	Internet	No browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
79	44	1/11/2023	1-1390343021567	112966849	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
80	44	1/11/2023	1-1390342968746	112402857	Internet	No browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
81	44	1/11/2023	1-1390343345300	112054836	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
82	44	1/11/2023	1-1390344172608	114792224	IOT Smart Service	IOT Complaint	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
83	44	1/11/2023	1-1390345441513	114764939	Internet	Slow Browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
84	44	1/11/2023	1-1390345556569	112290384	Internet	Modem Faulty	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
85	44	2/11/2023	1-1390361869479	114004471	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
86	44	2/11/2023	1-1390361211514	112424397	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
87	44	2/11/2023	1-1390362329382	112385891	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
88	44	2/11/2023	1-1390361652325	112111553	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
89	44	2/11/2023	1-1390363277143	114556041	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
90	44	2/11/2023	1-1390360816703	112293295	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
91	44	2/11/2023	1-1390363857538	112297476	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
92	44	2/11/2023	1-1390363858397	112490628	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
93	44	2/11/2023	1-1390364081246	112359306	Jawwy TV	STB Faulty	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
94	44	2/11/2023	1-1390363886657	112451942	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
95	44	2/11/2023	1-1390364253895	112451893	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
96	44	2/11/2023	1-1390364081892	114015508	Internet	Browsing intermittent	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
97	44	2/11/2023	1-1390365259484	112262641	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
98	44	2/11/2023	1-1390366002811	114034837	More than one service affected	Loss of signal	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
99	44	2/11/2023	1-1390366617930	114810612	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
100	44	2/11/2023	1-1390365643763	112220493	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
101	44	2/11/2023	1-1390368021152	114573173	More than one service affected	OLO ONT Down	Technical	Normal	Center	FTTH	Riyadh_Province
102	44	2/11/2023	1-1390367689904	112521676	Internet	No browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
103	44	2/11/2023	1-1390371028251	114667799	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
104	44	2/11/2023	1-1390375161507	115621558	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
105	44	31-10-2023	1-1390375228223	112268426	Internet	No browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
106	44	31-10-2023	1-1390374404592	114747101	Internet	No browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
107	44	31-10-2023	1-1390376293728	112048187	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
108	44	31-10-2023	1-1390376650195	114950114	Internet	No browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
109	44	31-10-2023	1-1390378065188	112339255	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
110	44	31-10-2023	1-1390379791646	112275351	Internet	No browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
111	44	31-10-2023	1-1390380107213	112443268	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
112	44	31-10-2023	1-1390380107967	114886884	Internet	No browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
113	44	31-10-2023	1-1390381223702	112571331	Internet	No Internet connection	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
114	44	31-10-2023	1-1390381223970	112490381	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
115	44	2/11/2023	1-1390381417122	115621932	More than one service affected	All services not working	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
116	44	2/11/2023	1-1390381906043	112448136	Internet	Modem Faulty	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
117	44	2/11/2023	1-1390382491385	112367674	Internet	No browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
118	44	2/11/2023	1-1390382781111	112004485	Internet	Slow Browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
119	44	2/11/2023	1-1390383483133	112454517	Internet	No browsing	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
120	44	2/11/2023	1-1390383320857	112766187	Internet	Browsing intermittent	Technical	Normal	CENTRAL	FTTH	Riyadh_Province
121	44	2/11/2023	1-1390383816294	112380271	More than one service affected	All services not working	Technical	Normal	CENTER	FTTH	Riyadh_Province
01-11-2023-CC

 

[MARK858]

I will try and have a look at this over the next couple of days if no-one else jumps in, but at the moment changing my system over to US date format will mess up some other work that I am doing.

 

[vmjan02]

I will try and have a look at this over the next couple of days if no-one else jumps in, but at the moment changing my system over to US date format will mess up some other work that I am doing.

sure take your time